J
jwrnana
What is VLOOKUP and its purpose?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Anne Troy
Try this to learn a perfect reason to use VLOOKUP.
http://www.officearticles.com/tutorials/order_form_or_invoice_form_in_microsoft_excel.htm
************
Anne Troy
www.OfficeArticles.com
http://www.officearticles.com/tutorials/order_form_or_invoice_form_in_microsoft_excel.htm
************
Anne Troy
www.OfficeArticles.com
S
swatsp0p
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.
HTH
Bruce
Â
ÂíÎÀ²¨
VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
À˳±
À˳±