Search columns and rows for values to return common value

  • Thread starter Thread starter Dale
  • Start date Start date
D

Dale

I have a table that I would like to retrieve data from by
using two different user inputs to specify the values in
the start of the columns and rows. I want the formula to
search for the value in the colums and the rows. Not by
specific columns or rows.

Example:

A1 SIZE
A2 10
A3 18
A4 30

B1 JA
C1 JK
D1 LJ
E1 HT

B2 15
B3 22
B4 27
C2 19
C3 26
C4 32

In two other cells a user might enter,

18
JK

Then in another cell I want to have the two user entries
to search the tables Rows and colums to return the value
from cell C3 or 26.
Then another user might enter,

10
JA

This should return the value from cell B2 or 15.


Any ideas?

Thanks.
 
Dale said:
I have a table that I would like to retrieve data from by
using two different user inputs to specify the values in
the start of the columns and rows. I want the formula to
search for the value in the colums and the rows. Not by
specific columns or rows.

Example:

A1 SIZE
A2 10
A3 18
A4 30

B1 JA
C1 JK
D1 LJ
E1 HT

B2 15
B3 22
B4 27
C2 19
C3 26
C4 32

In two other cells a user might enter,

18
JK

Then in another cell I want to have the two user entries
to search the tables Rows and colums to return the value
from cell C3 or 26.
Then another user might enter,

10
JA

This should return the value from cell B2 or 15.


Any ideas?

Thanks.
Click to expand...

Supposing your two cells for user entry are G1 and H1:
=INDEX(A1:E4,MATCH(G1,INDEX(A1:E4,,1),0),MATCH(H1,INDEX(A1:E4,1,),0))
 
Back
Top