Excel Magic Trick 1253: Can I Make VLOOKUP Use Column Headers? Yes: Use VLOOKUP & MATCH!

Learn how to get VLOOKUP to use Column Headers for the col_index-num argument by using the MATCH function. See how to lookup employee data using VLOOKUP and MATCH functions, Also see how to use Data Validation List feature to add a drop-down to a cell.

[francesly]

I learned excel from following your videos, they are clear and succinct!! Keep up the great work. Super helpful when you're adding columns and vlookup aren't dynamic to return the same data

[ExcelStrategy]

The VLOOKUP and MATCH combination wins !

[OzduSoleilDATA]

YEAH! This is POWER, and beautiful thin that the asker is thinking this way. Such a beautiful mind.

[SizzlesShashi]

This trick helped me today, will use this trick extensively from now on, thanks for this

[MySpreadsheetLab]

the hard coded column index number causes so many spreadsheet errors. thanks for video Mike!

[deanpournaras]

Awesome tips. Can not telly you how many hours would have been saved with this simple function. Great resource!

[alvisgosai]

Very well, just what I was looking for. Thank you so much !

[bohemaxxtum]

Great video again as usual from this great person.thank you so much.

[polc]

brilliant, so easy and yet so powerfull

[dougmphilly]

I have to assemble financial reports from a single download of data containing different divisions and companies. VLOOKUP has been my tool for this but when I need to add a new statement for a new company, i break out in hives making sure that new columns don't upset my summary reports. this takes out all the guess work and hand wringing.

[sararosengs]

I hope you can help with this..i want to do the same thing as this video but what if there are 2 criterias that need to be followed, for example based on this video the criteria is only ID, what if there is another 1 additional criteria. Any suggestion is greatly appreciated

[dghi]

What if column names are different, but data is same. How to use vlookup and match

[eCabinetstipsandtricks]

Wow Mike. That is some great info. How about a drop down for the column headers also. Is this possible?

[dannyzhu]

Can i setup a drop-down list in one cell with two name ranges?

[Sal_A]

Good stuff. Would the space operator lookup work in this situation too?

[Grandkidsmovies]

How to extract vertical data/table by using hlookup?

[alandouglas]

+ExcelIsFun
I've got a puzzle for you Mike,
I have two columns running side by side with random numbers (with decimals, that will change depending on other criteria). And I would like a formula that will find the which two values (one in each column) are the closest in value...

[amirchar]

I hope you can help with this.. I can't seem to find a way to do this. I import data on a weekly bases where new columns and rows are added or moved around on a regular basis. I would like to find a formula that will allow me to pull the value from a specific column and row header. We have been using Vlookups, but if a new column is inserted, then the vlookup will fail. For example: I would like to always return the value of a cell where the column name is Price and row name is Vendor X. the column and row names will not change, but they may get shifted left or right/ up and down each week, based on new columns and rows being inserted. Any suggestions are greatly appreciated.

[machi]

You could achieve the same result with the below, i think

=index($b$5:$e$11, match(b14, $b$4:$e$4, 0), match($a15$, $a$5:$a$11, 0))

[bondnikunj]

we have xlookup now so we can use spill and will do the same withouy the hazzle