Article updated on August 20, 2007

Question: Search in one of two tables at a time. Search for a value and the adjacent cell value is returned.

Answer: A10 is the tablename. B10 is the search value. And C10 is the answer (VLOOKUP(B10,INDIRECT(A10),2,0)

VLOOKUP(lookup_value; table_array; col_index_num; [range_lookup])
Looks for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify. By default, the table must be sorted in ascending order.

Returns the reference specified by a text string