Mr Excel & excelisfun Trick 40: VLOOKUP to 3 Different Lookup Tables (3 table_arrays)

See Mr Excel and excelisfun show how to do a VLOOKUP to 3 different tables using these tricks:
1)INDIRECT and CHOOSE
2)CHOOSE alone
3)INDIRECT with a defined name (named range)
4)CHOOSE with a defined name (named range)
Learn how to copy a sheet and paste a defined name with keyboard shortcuts.

Category:

Science & Technology

Tags:

• Excel
• VLOOKUP
• Different
• Lookup
• Tables
• three
• different
• table_arrays
• Define
• Names
• CHOOSE
• INDIRECT
• functions
• excelisfun
• Bill
• Mr
• Jelen
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[dmr450]

This is a great video. The volatile vs non volatile, the choose function, named ranges usage is truly great!

Really!

Thanks.

Dave

[ExcelIsFun]

@dmr450 , coming from a true Excel Master like you, that is quite a compliment!!!

[programSense]

man you guys are crazy...in a good way. This will really come in handy, I used nested if's for these situations and the formulas were too tedious.

[ExcelIsFun]

I am glad that that it is helpful!!

--excelisfun

[rameshsolonely]

i am so happy to see you new video every time it very very work full to me in my daily work i am working in F&B do you have easy formula to make accurate inventory .

how can i count by vlookup same code 2 time in one sheet  Sunjoy Kuwait thank you very much for help me to teach me more happy Holiday !!!!!!!!!!!

[ExcelIsFun]

For counting, try this video title:

Excel Magic Trick #180: COUNTIF function formula 21 Examples

For inventory, try:

Excel Magic Trick 348: Formula for Unit Inventory Total SUMIF function Trick

or

YTLE#79: Formula for Running Total (Inventory)

[ExcelIsFun]

EXCELlenttttttttttttt!!

I hope that we can come up with others that are nearly as cool!!!

[planiolro]

totally cool. One of the best duel I have ever seen. Superrrrrrrrrrrrrrrrr

[ExcelIsFun]

You are welcome! I am happy that the trick is useful!