In Excel what can I use for the XINDEX function from Lotus 123?

V

Val from ICB

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.
 
H

Harlan Grove

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

Ken Wright

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

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