Lookup in raw and column concurrently

  • Thread starter Dmitry Kopnichev
  • Start date

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

Advertisements

J

Jerry W. Lewis

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

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

Advertisements

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 :)
------------------------------­------------------------------­------------ ----
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Column Lookup? 3
Global raw and column insert in a workbook. 1
multiple column lookups 1
Lookup across columns 3
lookup with uneven columns 3
Lookup in multiple columns 7
two column lookup 3
Two-Column Lookup 2

Top