Home |
Search |
Today's Posts |
#1
|
|||
|
|||
In Excel what can I use for the XINDEX function from Lotus 123?
How can I have the formula look at a 2 different cells for values, match them
to a row and column on a chart and input the value at the intersection. The XINDEX function works this way in Lotus 123. |
#2
|
|||
|
|||
Val from ICB wrote...
How can I have the formula look at a 2 different cells for values, match them to a row and column on a chart and input the value at the intersection. The XINDEX function works this way in Lotus 123. The best Excel equivalents for the 123 formula @XINDEX(RNG,ColVal,RowVal) would be =INDEX(RNG,MATCH(RowVal,INDEX(RNG,0,1),0),MATCH(Co lVal,INDEX(RNG,1,0),0)) =VLOOKUP(RowVal,RNG,MATCH(ColVal,INDEX(RNG,1,0),0) ,0) =HLOOKUP(ColVal,RNG,MATCH(RowVal,INDEX(RNG,0,1),0) ,0) |
#3
|
|||
|
|||
Data Table in A1:H8
Column headers in B1:H1 Row Headers in A2:A8 Column value to lookup in A12 Row value to lookup in A13 =INDEX($A$1:$H$8,MATCH(A12,A1:A8,0),MATCH(A13,A1:H 1,0)) -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Val from ICB" <Val from wrote in message ... How can I have the formula look at a 2 different cells for values, match them to a row and column on a chart and input the value at the intersection. The XINDEX function works this way in Lotus 123. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return value with using Excel function | New Users to Excel | |||
Excel Logic Function | Excel Discussion (Misc queries) | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Missing function in Excel 2003 | Excel Discussion (Misc queries) | |||
IF/ LOOKUP FUNCTION - Excel 2000 | Excel Worksheet Functions |