Harlan Grove wrote:
"Aladin Akyurek" wrote...
It would be much easier if you specified what Range refers to and the
range where "Salary" occurs.
No it wouldn't. OP's question is crystal clear if you know 123. If you don't
know 123, perhaps you should let those who do respond.
[...]
I don't think that would count as a prerequisite in this particular case.
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("Sa lary",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.
|