VLOOKUP on Multiple Columns and Return Text

Learn Excel Fast:

You want to perform a lookup with VLOOKUP, but, there are multiple lookup columns. So, what are you supposed to do? Combine them into a single lookup column? That is certainly one option, but, as with just about anything in Excel, there are multiple ways. In a previous blog post, I showed one way to do this with SUMIFS when the value you want to return is a number. In this video, I'll demonstrate how to return text values when there are multiple lookup columns using a Get & Transform query.

[annabelletang]

THANK YOU SO MUCH SIR. YOU SAVED ME FROM TEARS. THANK YOU SO SO SO SO SO VERY MUCH.

[morninglight]

Holy guacamole, Batman! That was what I needed and more!! Yay!!

[ziaehsan]

Thank you Jeff. It was really helpful.

[muzamilmehdi]

Thank you ever so much for this!!!! Very well explained, and made it so easy to execute. Was stuck in if, and vlook up loops.

[SMCGPRA]

Thank very much Sir nice feature explained very clear and concise.👍🙏

[jaanaan]

It was really helpful! thank! hey guys press "LIKE"!

[stalloneedward]

Iam not able to select tables, can you please help me on this?