Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 6th 05, 06:12 AM
Dmitry Kopnichev
 
Posts: n/a
Default 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   Report Post  
Old October 6th 05, 01:04 PM
Jerry W. Lewis
 
Posts: n/a
Default

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   Report Post  
Old October 6th 05, 03:25 PM
ΓΙΑΝΝΗΣ Χ.Β.
 
Posts: n/a
Default

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   Report Post  
Old October 6th 05, 10:03 PM
Ken Wright
 
Posts: n/a
Default

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   Report Post  
Old October 7th 05, 06:31 AM
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)) ?







  #6   Report Post  
Old October 7th 05, 06:32 AM
Dmitry Kopnichev
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 12:04 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017