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

what a legend

may god bless you for this one

7

Watching in 2023

Old is gold

Sir your formula and way of teaching is awesome ...i would like to connect if you provide online class after paying the fees.

well done

Hi, I, wondering if you can help me craft a formula. I don’t need the “&” in my scenario but an either or.

I have sheet one where E2 & F2 tho not all complete contain contract & delivery order # s that I want to match against C2 & D2 on sheet 2 (from another source) to obtain a plan # in B2 also on sheet 2. Whatever the right formula is I will just double click to have it expand to the columns I need.

Is there a way to craft a formula of sheet 1 to have it use E2 & F2 values (contract & delivery order #) search array of contract # & delivery orders on sheet 2’s C2 and D2 to then give me the corresponding plan # in B2?

great solutions

Thanks, this tutorial is so helpful

This is Awesome trick and you are a life save:)

old but goldmine

I am so glad you exist in the world for me.
Regards,
Some poor schmoe hitting keys

11 years ago u made this video 😮😮😮😮😮😮😮😮😮

Thank you for this video! Very informative :D

After 11 years it is still very helpfull sir! Thank you very much for your tricks!!

. . Rti

Thank you! Super helpful!

Thank you for the excel support

i have complete nightmare finishing my report and this tutorial help me to make it through. thank you!!

Gret a tutorial on =IFERROR(VLOOKUP() function Mike.I have tried without heleper column and it works fine, but I think its kind of easier to have one helepr column already sorted out within a table rather then formula. Thanks.

wow, this is great. Just wondering why you fixed your table? Thanks

Thaaaank you so much!! I'm 10 years late!! So, the past few weeks, I have to manually check it one by one.. imagine, 600-700 rows in a spreadsheet! And I have 20 or more of that to check!! Reason is that there was an extra word, and I don't know what to do since vlook up is not working. Luckily, I bump here!! I am a subscriber but never paid attention on this part.. many many thanks

hey!
Thank you!

Thanks once again man.
I had to work with more than 7 million data points and thanks to you those data's can be treated with your trick, much easier/faster :) :D

Hi, I am unable to do when "Date" format is there . Requesting you to suggest me on same . It is very urgent and important for me..

Regards
Rabindra
9845411959

Your videos are super easy to understand and you have a way with explaining things, I don't know why but I only ever understood excel from you. learned excel from you and became proficient, you changed my life in many ways that can't really be put into this comment and had gotten me out of a desperate situation again that is too long for this comment. so I'm just gonna say thank you, although you deserve more than this .

🈶️🇹🇭看妹妹私🈲️视频➕微信号hot5383🈶️🈶️烦烦烦反反复复反反复复反反复复g

Thank you so much! This works way better than index+match !!

This was a big help as I used the joining column to allow me to combine data from two worksheets, which had 2 common columns and pick up the key data from the second sheet putting it in the right place on the first sheet. Nice tidy trick and showing the IFERROR part was a classy touch, many thanks

i need help comparing two cells with a high and low value, one of the cells is blue. Return 1 if the lowest value is blue color or return zero if the higher value is blue color. how do i perform this task in excel?

Love this trick. Used it right now for the first time and it saved me a lot of working time. Thanks for your videos!!!!

What simple idea to solve a complex problem, much appriciated.

Please answer my question, I need your help :) I have 3 column
Column1cell text is: 123456ABCD987654
Column2cell text is: ABCD
Column3cell: function
I want to find if consequitive 4 symbol anywhere in Column1cell matches with Column2cell and vlookup them.

saved me from getting fired

Yes, sir! Thanx for the video!

Very helpful and easiest to learn on the internet! Thanks so much

Love You!!!  Thanks

Very nice

very much helpful! Thanks

Genius! Thank you very much! I've been fiddling with Index/Match formulation and nothing worked for me. I'm glad I stumbled upon your video as I was about to pull my hairs! Thank you soooo muchhhh!

THANK YOU SO MUCH:))))))

Thanks a lot bro!!
You really fixed a big puzzle for me. Now i can apply Vlookup also with duplicate values with ur amazing trick!!

Thanks a lot. This really help me to save my time.

Is there a way to use vlookup to match 2 values with vlookup ?  I would like to see the above video without having to join, is that possible?

You are a Genius!!!

Dude! you are amazing i was stuck with my course work (because i didn't know ang how to use this specific formula) and I in panic was searching something to save me in internet and YOU DID you actually made my day. Thank you.

What if you are working with dates? Example 4/20/2015-CHI etc? The dates come out looking like this (42092).?

This really helps... thank you...

This guy's voice sounds like Ross Geller from Friends.