Mr Excel & excelisfun Excel Trick #1: Two 2 Way Lookup

See Mr Excel and excelisfun demonstrate two methods to do a two way lookup on a table array:
Mr Excel: MATCH and INDEX functions in one formula to retrieve a value from the intersection of a row header and column header in a table array (table of lookup values)
excelisfun: Names, INDIRECT function and the Space Intersector Operator in one formula to retrieve a value from the intersection of a row header and column header in a table array (table of lookup values)

YTL Excel #119: Amazing Lookup Solution!
Excel Lookup Series #11: INDEX & MATCH functions Two 2 Way Lookup
Excel Name Trick #7: INDIRECT function, Names and LOOKUP
Mr Excel & excelisfun Excel Trick #1: Two 2 Way Lookup
MrExcel's Learn Excel #965 - Two-Way Lookup
Excel Magic Trick #136: Two 2 way lookup with VLOOKUP & MATCH

Category:

Science & Technology

Tags:

• Excel
• MATCH
• INDEX
• INDIRECT
• Two
• Way
• lookup
• excelisfun
• Bill
• Mr
• Jelen
• Mike
• Gel
• Girvin
• Highline
• Community
• College
• Duel
• Dueling

[Gbell3587]

awesome vid, i never knew how to use vb like user forms.....is there any other turotials on using vba user forms?

[ExcelIsFun]

@Gbell3587 , Search Bill Mr Excel Jelen YouTube site, he has a few videos about User Forms:

.youtube [dot] com/bjele123

[ssilentwish]

plz type you site address where from i can take that sheet and practice

[ExcelIsFun]

@ssilentwish , Here:

people.highline.edu/mgirvin/Ex­celIsFun.htm

[lera5266]

just love your videos...you have to open your own excel school.. you are such a great teacher!!!!!!!!!!!!

[ExcelIsFun]

@lera5266 , YouTube is the school! I am glad that you like the videos!

[MrDevah]

You guys can control the government :P

[doncarous]

hi mr excel,i am fresh graduate who is desirous of pursuing a career in finance,i am novice in excel and need your help.my email:carous_g2000@yahoo.com

[Lucream2]

Hi Mr Excel thanks for your videos there are all great. I have some questions for for you. Is it possible to make a pop up calendar in MS Excel 2007? If so could you make a video about this? Or do you have a DVD that I can purchase to learn how it is done?

[mos233389]

I had a similar problem to solve recently on a multiple foreign exchange rate conversion but couldn't get the match to work. I used a VLOOKUP with a MATCH embeded to find the respective FOREX rate by specifc date within a FOREX by month table. Thanks for the tips.