Tuesday, April 26, 2016

VLOOKUP in 3 Images

Those 3 images from the book Dynamic Infographics, can help you to understand the "VLOOKUP steps". Try the second image in your excel and follow the colors.

Blue - What are you looking for?
Red - Where do you want to search?
Purple: If you found, which column Excel will retrieve your data?
Yellow: Exact match? Ok, type "0" (zero).

Have fun :)


If you want to learn more about vlookup, hlookup... Try my book "Dynamic Infographic":

No comments:

Post a Comment