Index/Match or Vlookup

S

S

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!!!
 
J

JMB

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

Replace 22 and 23 with cell references if desired.
 
R

Rick Rothstein

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))
 

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

Top