"Aladin Akyurek" wrote...
Harlan Grove wrote:
....
Excel doesn't have an equivalent for 123's @XINDEX (more of a double
lookup
than an index operation). The following are the Excel equivalents.

VLOOKUP(A4,Range,MATCH("Salary",INDEX(Range,1,0) ,0),0)

HLOOKUP("Salary",Range,MATCH(A4,INDEX(Range,0,1) ,0),0)

INDEX(Range,MATCH(A4,INDEX(Range,0,1),0),
MATCH("Salary",INDEX(Range,1,0),0))

I did not list these choices simply in order to avoid all those inner
INDEX calls. Another reason is that I dislike the idea of including the
match ranges in the specification of Range.

If the OP were dealing with static column headings, then @XINDEX wasn't the
right choice in 123. If neither column nor row headings were static, then
you can't hardcode either row or column index in HLOOKUP or VLOOKUP,
respectively, in thich case those unloved match ranges would need to be
referenced inside MATCH calls.

Also, idiot-proofing requires including the match ranges with the data
ranges. If the range contains headings in the leftmost column and top row as
well as filler rightmost column and bottom row (empty but shaded or
containing | and _), then rows and columns may be inserted or deleted at
will inside the range and the formulas I gave will always work. If you
specify only the data, you can't insert columns immediately to the right of
the leftmost column or row headings or immediately below the top row of
column headings.