If your column A4:A13 and your row A2:J2
Vlookup from column to row:

{=VLOOKUP(C4;CHOOSE({1;2};A4:A13;TRANSPOSE(A2:J2)) ;2;0)}


Vlookup from row to column:

{=VLOOKUP(C4;CHOOSE({2;1};A4:A13;TRANSPOSE(A2:J2)) ;2;0)}


of course C4 = Lookup_value

Ioannis Varlamis ,Athens, Greece


"Dmitry Kopnichev" wrote:

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