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