LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default Complex lookup issue

Hi,
Does anyone know how to do a double "lookup" in Excel?

My situation is like this, I want to search a specific data on Column A
(under count), then after it's found I want to search the corresponding
matrix data for that item from the headers of Columns B to E. Then the result
will be put into Column C of my "FILL-IN" worksheet


Example, below is the worksheet (named DATA-REF) I want to look data to:
Column A Column B Column C Column D Column E
count dog cat mouse fish
20 100 monster 300 400
30 trip counta sea data-?
34 99 1001 210 22
100 qwqe asdas gdg jhg
999 qwww 323 sfd 8686


Below is my other worksheet named (FILL-IN) that will search the data in
"DATA-REF" worksheet and fill the result in Column C:
Column A Column B Column C
data Anim data Final data (the column where I need to fill in the data)
20 cat ???? (the lookup result should be monster)
34 mouse ???? (the lookup result should be 210)
999 fish ???? (the lookup result should be 8696)


The "????" in my worksheet "FILL-IN" is the data I'm looking for in the
"DATA-REF " worksheet. So meaning if I lookup "20" on Column A in worksheet
"DATA-REF" after it's found I want to lookup "cat" as per reference to Column
B on my worksheet "FILL-IN" then search the "cat" in "DATA-REF" corresponding
to "20" on Column A of my "DATA-REF" worksheet. So the final lookup result
should be "monster", as what I written there (the lookup result should be
monster).

Sorry if it sounds confusing but that is the best I can do. Pls help!

Thanks!

 
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Complex Array sorting issue Tubster Excel Worksheet Functions 5 July 10th 08 11:38 PM
Complex MAX and Lookup Heliocracy Excel Discussion (Misc queries) 5 April 24th 08 10:33 PM
A somewhat complex (to me at least) Nested IF issue The Narcissist Excel Worksheet Functions 0 January 23rd 08 12:07 AM
Complex lookup bobb Excel Worksheet Functions 0 October 14th 06 08:33 PM
Help with complex index array issue kkendall Excel Worksheet Functions 4 August 5th 05 10:15 PM


All times are GMT +1. The time now is 04:30 PM.

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

About Us

"It's about Microsoft Excel"