Advanced VLookup with nested functions by Chris Menard

In this video, I will do a Vlookup with an If Statement to pull from two tables instead of one. I do a Vlookup within a Vlookup. That is a nested Vlookup, and I use a Vlookup to pull from two fields instead of one by using a helper column.

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[johansanjaya]

wow, that nested vlookup really mindblowing for me. i mean, we can use that if the helper table more than 1 and it has some relation between the table (like SQL table). really respect and appreciate you sir

[ExcelSquad]

If it is possible for you, Could you share this file sir.