From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Using array formulas and the MATCH function for complex lookups

Using array formulas and the MATCH function for complex lookups

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Using array formulas and the MATCH function for complex lookups

“

- When you're trying to match up data from different lists, and pull up corresponding information, you're likely to want to use the VLOOKUP function. But when the lists have different name entries, take a look on this worksheet called extended array. Over in columns A and B we see first name last name, over in column G we see last name first name in the same cell in reverse order. Now imagine these lists are in different locations, In the list on the left we wanted to pick up the ID number, and this has already been done. I want to expose this formula so you can see it. In the list here we're trying to come up with the ID number, based on the entries over in columns G and H. So here's a VLOOKUP function, and it's doing something that you might not have seen. VLOOKUP is beginning here by taking the names, imagine it's picking up the name Randall, putting in a comma and a space behind it, and then the name Yvonne. This is coming out of cells B2 and A2. So this construction results in…

Contents