# Lookup in raw and column concurrently

D

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

J

#### Jerry W. Lewis

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

G

#### Guest

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

K

#### 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
------------------------------­------------------------------­----------------

D

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

D

#### Dmitry Kopnichev

Thank you, Ken Wright!
Ken Wright said:
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
------------------------------­------------------------------­------------ ----