Excel Magic Trick 398: VLOOKUP with Two Lookup Values (IFERROR function also) 2 lookup values

[broomvertigo]

great video. any chance of communicating with you directly via email/skype? i am so close to getting done what I need in excel...... but need some expert input to finalize

[husyadaddynoodle]

Great video, helped me out of a pickle! i used this method for 3 lookup values! And a so called "expert" told me it couldnt be done! ExcellsFun youve shown yet again you are the Excell Master! Thanks

[ExcelIsFun]

@husyadaddynoodle , I am glad that this video helped! There is no doubt that if someone tells you that it can't be done in Excel, it usually can be done (not always, but usually)!

[broomvertigo]

@husyadaddynoodle great start to my issue, BUT i need HELP!!!

I have 2 worksheets within 1 file. There are 10 columns (identical fields in BOTH worksheets)

I want to compare column C in wrksht 1, to column C in wrksht 2

IF 2 cells are identical between the 2 worksheets, I want to extrapolate the email adres to a 3rd wrksht

MY ROUGH LOGIC IS BELOW

=1c = 2c then DISPLAY

STEP 2 Macro -- this is a more advanced formula for comparing MULTIPLE columns

=1(x+y+z) = 2(x y z), then DISPLAY

[ExcelIsFun]

@broomvertigo , Try this alternative site (not the same as excelisfun) that is set up specifically to ask Excel questions and have dialog:

mrexcel [dot] com/forum

(mrexcel [dot] com is not affiliate's with excelisfun at YouTube)

This site has many people who can help you get the solutions you want.

If you ask a carefully constructed question, you will get answers quickly

[LaCastanon]

You are THE Excel Guru, I learned more from watching your videos than from my textbook. Thank you and keep the videos coming!!!!

[ExcelIsFun]

@LaCastanon , Cool! I am glad that the video helped!

[ashyz87]

You are an Excel God! You have helped me out so many times. I cannot begin to thank you enough.

[ExcelIsFun]

@ashyz87 , no god, just a guy having fun with Excel. I am glad that the videos help!

[Unplugged704]

Subscribed!

[mickey8860]

Thank you for your teaching!^^

[ExcelIsFun]

@mickey8860 , you are welcome!

[Astroboy25]

ExcelIsfun. I have no other words to say but a Huge thank you! I love all your videos. They are really a life saver!! Thanks a lot for all the effort you have put on them! It's greatly appreciated :-)

[ExcelIsFun]

@Astroboy25 , You are welcome!

[mindulis2006]

thanks a lot... that's what i needed and i looked for many hours..

[ExcelIsFun]

@mindulis2006 , I am glad that it helped!!

[55YuanYuan]

where to download it? I'm not familiar with youtube.

[ExcelIsFun]

click on the blue excelisfun link and then watch the video that auto plays...

[violajean]

I learned about the IFERROR here, I always use If(ISERROR at work, IFERROR is much simpler.

[ExcelIsFun]

We still have to be careful because if we send our workbook with the IFERROR to other people that don't have Excel 2007, then will get a #NAME? error. I just wish that everyone (including businesses) would be kind to themselves and get the new version because there are many elements like this IFERROR that are much better than earlier versions. Excel 2010 is coming out next April, so maybe then more people will upgrade!

[ExcelIsFun]

In particular, for large spreadsheets, IFERROR is much faster calculating that the old way we did it with "If(ISERROR" and listing the bulk of the formula twice.

[Mynotoar]

Seems very interesting :P. I have yet to find a practical application of VLOOKUP as mostly what I do on Excel is mess around, the only serious spreadsheet I created was way before I started watching your tutorials - although I have since made some changes to make it look better after watching your vids :P.

[ExcelIsFun]

VLOOKUP is one of the most common functions used in the working world.

Interviewers love to ask people if they can use VLOOKUP.

[fitnessfreaky]

that is true! Mynotoar shocks me with his comment

[Mynotoar]

Well, shocking people is a speciality of mine.

[ExcelIsFun]

What is great about being human is that we are lucky to meet all sorts!!

[Mynotoar]

I didn't say it had no use, I meant that *I* haven't thus far found a scenario in which to use VLOOKUP.

[ExcelIsFun]

What is great about being human is that we are lucky to meet all sorts!!