Excel:Advanced search between two tables

Popular categories

Dashboard reporting with excel This e-book teaches you how to create your own Excel dashboard reports, starting from scratch. Learn how to create mini-charts, how to use Excel's Camera tool, how to set up Excel databases, and a lot more.

Excel Worksheet-Formula Add-Ins allows worksheet formulas to change chart settings. For the first time ever, your formulas can create traffic-light charts, highlight chart elements, assign number formats, and much more.

Get Digital Help > Excel > Excel:Advanced search between two tables

← Previous post -

Filed in Excel on Aug.20, 2007. Email This article to a Friend

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.

INDIRECT(ref_text;[a1])
Returns the reference specified by a text string

Search for a cell in a table and then display the column title in excel

Search and display all cells that contain all search strings in excel

Search three columns on three sheets, part 2

Disable autofit column widths for all pivot tables in a sheet