View Single Post
  #5   Report Post  
Dmitry Kopnichev
 
Posts: n/a
Default

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