I found what I wanted. It is =INDEX('2004'!$A$11:$DV$1437;
MATCH($A28;'2004'!$A$11:$A$1437;0); MATCH(J$3;'2004'!$A$11:$DV$11;0)). Is
there a one function expression?
"??????? ?.?." сообщил/сообщила в новостях
следующее: ...
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)) ?
|