vlookup Archives • My Online Training Hub

July 29, 2021

VLOOKUP in Power Query Using List Functions

If you've done lookups in Power Query to pull values from one table into another, you may have used a

May 16, 2013

A few weeks ago David T asked me to help him understand a VLOOKUP formula in a workbook he’d inherited

November 21, 2012

This week I had a question from Diedre asking if she can use VLOOKUP to check multiple sheets…. 17 different

October 3, 2012

This Excel Factor tip was sent in by Bob Cooke of Lincolnshire, England. Words by Mynda Treacy Last week Bob

September 22, 2012

This Excel Factor tutorial was sent in by Bryon Smedley of Bristol, Tennessee. Words by Bryon Smedley. Enter your email

February 15, 2012

I had an email from Bobcat today asking how to lookup data that is spread across multiple columns. Table

December 7, 2011

For some of us we use the VLOOKUP function all the time and for the most part is does exactly

August 31, 2011

Wildcards *?~....what am I talking about? And no, it's not an expletive. Let’s start with an example. COUNTIF using Wildcards

June 22, 2011

If you ever work with large tables of data and you want to insert a VLOOKUP formula that dynamically updates

February 1, 2011

A little while ago I showed you how to do a lookup to the left using the INDEX and MATCH

November 26, 2010

The Excel HLOOKUP formula is just like the VLOOKUP formula, only the table you are looking up is laid out

September 22, 2010

In my previous Excel VLOOKUP formula tutorial I mentioned that there are two ways you can use a VLOOKUP but

September 20, 2010

The Excel VLOOKUP formula is my favourite! Perhaps because it was one of the first formulas I mastered. It gave