If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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!!! |
#2
|
|||
|
|||
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!!! |
#3
|
|||
|
|||
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!!! |
Thread Tools | |
Display Modes | |
|
|