View Single Post
  #4   Report Post  
Ken Wright
 
Posts: n/a
Default

Try something like this:-

Assuming your values in A2:J10, with row/col headers in A2:A10 and B1:J1

and your look up values in A16 and A17

=INDEX($A$1:$J$10,MATCH(A16,$A$1:$A$10,0),MATCH(A1 7,$A$1:$J$1,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 :-)
------------------------------*------------------------------*----------------


"Dmitry Kopnichev" wrote in message
...
Hello
Is there a function
NameOfFunctionAnalogOfLookup(lookup_valueInFirstCo lumn,lookup_valueInFirstRo
w,table_array) or an analog of
VLOOKUP(lookup_value,table_array,MATCH(reference)) ?