Vlookup function

[Dana]

Hi All,
I am familiar with the vlookup function - vlookup(lookup
value,table_array,col_index_num, range_lookup). If I had
multiple table_arrays to look from (e.g., range1, range2,
etc.), what syntax should I enter in the table_array so
that I don't have to type in the table_array multiple
times? I am thinking of just creating a table of all range
names and referring to the table as the table_array of my
vlookup function.

Thanks a lot!

 

[Norman Harker]

Hi Dana!

Just use an absolute reference to your table_array

Example, if your table is in P1:Q30

Amend the reference in your VLOOKUP to $P$1:$Q$30

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Wednesday 6th August 2003: Bolivia
(Independence Day), Bulgaria (The Transfiguration), Jamaica
(Independence Day), United Arab Emirates (Accession of H.H. Sheikh
Zayed). Observances: Hiroshima Day (08:15 Local Time 6th August 1945),
Hiroshima Peace Ceremony (Shinto), The Transfiguration (Christianity).
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.