Hi Murtaza!
Description:
Locates a specified value in the leftmost column of a specified table,
and returns the value in the same row from a specified column in the
table
Syntax:
=VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
lookup_value: The value to be found
table_array: A table of information in which data is looked up
col_index_num: The column number in table_array from which the
matching value must be returned
range_lookup: A logical value that specifies whether you want to find
an exact match or an approximate match. If TRUE = approximate match is
returned FALSE = Exact
If you don't find help useful, then you should finmd a lot of examples
if you do a Google Search on VLOOKUP. Ron de Bruin's Google Search 6
is very useful for this:
http://www.rondebruin.nl/Google.htm
Also see:
Dave McRitchie:
http://www.mvps.org/dmcritchie/excel/vlookup.htm
Here's an example of VLOOKUP looking up grades in a table:
=IF(B2="","",VLOOKUP(B2,$G$2:$H$6,2))
The mark in B2 is being looked up in the second column of the table in
G2:H2
Here's an example where the table array is inside the VLOOKUP formula:
=IF(B2="","",VLOOKUP(B2,{0,"F";0.5,"P";0.6,"C";0.8,"D";0.9,"H"},2))
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
