Index/Match or Vlookup
 

I need help to return a cross-reference:

Age/Age 20 21 22 23
20 1.25 1.26 1.27 1.28
21 1.15 1.16 1.17 1.18
22 1.05 1.06 1.07 1.08
23 0.95 0.96 0.97 0.98

Example: I need to return at horizontal age 23 and vertical age 22, the
return should be 1.08. What's the best formula to use? I've been at this
all night and I still can't get the formula correctly...please help!!!

Index/Match or Vlookup
 

Try
=Vlookup(22, A1:E5, Match(23, A1:E1, 0), 0)

Replace 22 and 23 with cell references if desired.

"S" wrote:

I need help to return a cross-reference:

Age/Age 20 21 22 23
20 1.25 1.26 1.27 1.28
21 1.15 1.16 1.17 1.18
22 1.05 1.06 1.07 1.08
23 0.95 0.96 0.97 0.98

Example: I need to return at horizontal age 23 and vertical age 22, the
return should be 1.08. What's the best formula to use? I've been at this
all night and I still can't get the formula correctly...please help!!!

Index/Match or Vlookup
 

Give this formula a try (although it would be better to put the 22 and 23
constants in their own cells and then use a cell reference for each (in
place of the constant value in the formula)...

=INDEX(A1:E5,MATCH(22,A1:A5,0),MATCH(23,A1:E1,0))

--
Rick (MVP - Excel)


"S" wrote in message
...
I need help to return a cross-reference:

Age/Age 20 21 22 23
20 1.25 1.26 1.27 1.28
21 1.15 1.16 1.17 1.18
22 1.05 1.06 1.07 1.08
23 0.95 0.96 0.97 0.98

Example: I need to return at horizontal age 23 and vertical age 22, the
return should be 1.08. What's the best formula to use? I've been at this
all night and I still can't get the formula correctly...please help!!!