|I'd prefer that you try it on your own first. We all learn better by doing than by having someone do it for us. That's how most of us who answer questions in this forum learned what we know.|
Here's an example of how VLOOKUP works...
Let's say this is my "database"...
A B C
1 SS# Name Team
2 3425 Tom Blue
3 1243 Bill Red
4 5454 Fred Yellow
5 1090 Sue Green
Here is the syntax of VLOOKUP, directly from the Help files:
VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)
- The lookup_value would be any value that you want to find in the first column of the database
- The lookup_array is the database (A1:C5)
- The col_index_num is the data you want to pull from the database, e.g. Name or Team
- The range_lookup tells Excel if you want to find an exact match of the lookup_value or not. You need to review the Help files to see how this argument is used.
So, if you used this formula:
=VLOOKUP(1243, $A$1:$C$5, 2, 0)
You would see Bill in the cell since VLOOKUP will look for 1243 in the first column of the lookup_array which it will find in Row 3.
It will then return the value from Column 2 of the lookup_array since we used 2 as the col_index_num.
=VLOOKUP(1090, $A$1:$C$5, 3, 0)
would return Green.