from Excel HELP -- -Searches for a value in the first column of a table
array and returns a value in the same row from another column in the
table array.
The V in VLOOKUP stands for vertical. Use VLOOKUP instead of HLOOKUP
when your comparison values are located in a column to the left of the
data that you want to find.-
Example: In cell A1 you have a value, say "Bob". Elsewhere you have a
table named "rates" that lists employees in one column and their pay
rate in the next.
In B2 you would enter:
=VLOOKUP(A1,RATES,2,0)
This would look for the value in A1 (Bob) in the rates table. If
found, it would return his pay rate.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.