Select by multiple criteria (Excel 2003)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I search for a value in a table based on variable row names and column
names? I have a table with rows that are labeled 1-11 and columns that are
labeled 1-6. I need to retrieve a value from the table that may have
reference of row 3 and column 4, or row 1 and column 6 and so on and the
references are in other cells adjacent to my formula cell. I'm trying to
build a formula in a cell on another worksheet that will search and retrieve
this data from a table on another worksheet.
 
Hi!

Take your pick....

Table is in the range A1:G12

A15 = row reference 3
A16 = column reference 4

=VLOOKUP(A15,A2:G12,MATCH(A16,A1:G1,0),0)

=INDEX(B2:G12,MATCH(A15,A2:A12,0),MATCH(A16,B1:G1,0))

Biff
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
Excel VBA 1
Trying to add column headings to array formula 1
Retrieve data based on 3 criteria 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Summing cells based on mulitiple criteria over mulitple columns 0
Scrabble Value calculation for Welsh words 0
Array formula using sumproduct & vlookup 6

Back
Top