Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Lookup in raw and column concurrently
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)) ? |
#2
|
|||
|
|||
What you are looking for is not clear to me. Can you describe it in
English? 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)) ? |
#3
|
|||
|
|||
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)) ? |
#4
|
|||
|
|||
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)) ? |
#5
|
|||
|
|||
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)) ? |
#6
|
|||
|
|||
Thank you, Ken Wright!
"Ken Wright" / : ... 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)) ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|