Table Lookup formula where 2 known values are inside array



I am using Excel.

Please help, I am stuck on a non-typical table lookup
I regularly use =lookup to get values where the relationship is 1:1
e.g. in a cell, I put a value, I use =lookup for that value's meaning

I need to do this, but the lookup is a table, not a 1:1 column match
Row 1 is a header, one of my search values
Column 1 is a value I want to find
the table (array) contains the other known value

I need do do a enter values in 2 cells, and have a lookup return a value
based on the value it looks up.


-- | 1 | 2 | 3 | 4
w | a | d | h | i
x | b | e | i | j
y | c | f | j | k
z | d | g | k | l

in my lookup, one cell has the value 2, This should specify to use the
column with the value 2 in the first row
The other cell has the value f. The formula I am having a hard time
figuring out needs to return the value in column 1, which in this case is the
letter y.

I have tried vlookup, hlookup, match and so on, but I am just plain stuck.
Please help.

T. Valko

Try this:

With your table in the range A1:E5

A10 = column lookup_value = 2
B10 = table lookup_value = F



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

Scrabble Value calculation for Welsh words 0
Double V lookup 1
lookup and return column number 2
vlookup 1
Sum / Lookup 9
Vlookup array formula problem 2
Vlookup Function 1
Formula require for complex lookup 4