Lookup in raw and column concurrently

[Dmitry Kopnichev]

Hello
Is there a function
NameOfFunctionAnalogOfLookup(lookup_valueInFirstColumn,lookup_valueInFirstRo
w,table_array) or an analog of
VLOOKUP(lookup_value,table_array,MATCH(reference))?

 

[Jerry W. Lewis]

What you are looking for is not clear to me. Can you describe it in
English?

 

[Guest]

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

 

[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(A17,$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]

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?

 

[Dmitry Kopnichev]

Thank you, 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(A17,$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
------------------------------­------------------------------­------------ ----