Cross Reference Formula
 

In my previous question:

I need to find a formula that first looks across the top row to find a
number
and then down the first column and results with the intersecting cell.
1 2 3 4 5
a 3 6 7 8 4
b 2 5 7 5 6

Excmple: when i reference 3-b, I need the result to be 7. THis is HLookup
and V lookup, but how do i combine these two formulas? HELP!

I failed to state that the 3 and the b are in separate cells on another
worksheet. How does this change the formula?

Cross Reference Formula
 

Hi,

Try this

=INDEX(A1:D10,MATCH(E1,A1:A10,0),MATCH(F1,A1:D1,0) )

Where A1 - D10 is the entire matrix including row and column headers
E1 contains the row search value
f1 contains the column search value

Mike

"mjsam" wrote:

In my previous question:

I need to find a formula that first looks across the top row to find a
number
and then down the first column and results with the intersecting cell.
1 2 3 4 5
a 3 6 7 8 4
b 2 5 7 5 6

Excmple: when i reference 3-b, I need the result to be 7. THis is HLookup
and V lookup, but how do i combine these two formulas? HELP!

I failed to state that the 3 and the b are in separate cells on another
worksheet. How does this change the formula?

Cross Reference Formula
 

And I missed that the lookup references are on another sheet

=INDEX(A1:D10,MATCH(Sheet2!E1,A1:A10,0),MATCH(Shee t2!F1,A1:D1,0))

Mike

"Mike H" wrote:

Hi,

Try this

=INDEX(A1:D10,MATCH(E1,A1:A10,0),MATCH(F1,A1:D1,0) )

Where A1 - D10 is the entire matrix including row and column headers
E1 contains the row search value
f1 contains the column search value

Mike

"mjsam" wrote:

In my previous question:

I need to find a formula that first looks across the top row to find a
number
and then down the first column and results with the intersecting cell.
1 2 3 4 5
a 3 6 7 8 4
b 2 5 7 5 6

Excmple: when i reference 3-b, I need the result to be 7. THis is HLookup
and V lookup, but how do i combine these two formulas? HELP!

I failed to state that the 3 and the b are in separate cells on another
worksheet. How does this change the formula?