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.
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.
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(ColVal,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)
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:H1,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 [email protected]> wrote in message
news:[email protected]...
> 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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks