Learning how to create VLookups

I need to learn how to create vlookups. I have Data in column G, I and K that I need to have looked up in Column C. If the item is found I need to return "No". If the item is not found I need to re...

excel

NikolinoDE
Apr 02, 2021
lizalexandersurgical

The basics of using VLOOKUP.

In the Formula Bar, type =VLOOKUP().
In the parentheses, enter your lookup value, followed by a comma. This can be an actual value, or a blank cell that will hold a value: (H2,
Enter your table array or lookup table, the range of data you want to search, and a comma: (H2,B3:F25,
Enter column index number. This is the column where you think the answers are, and it must be to the right of your lookup values: (H2,B3:F25,3,
Enter the range lookup value, either TRUE or FALSE. TRUE finds partial matches, FALSE finds exact matches. Your finished formula looks something like this: =VLOOKUP(H2,B3:F25,3,FALSE)

I would be happy to know if I could help.

Nikolino
I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

Forum Discussion

Learning how to create VLookups

Resources