Forum Discussion
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 return "Add". The columns have several rows within them.
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.
2 Replies
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.
- Why not upload a simple file so that it would be easy to provide an exact solution?
