Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Complex Array sorting issue | Excel Worksheet Functions | |||
Complex MAX and Lookup | Excel Discussion (Misc queries) | |||
A somewhat complex (to me at least) Nested IF issue | Excel Worksheet Functions | |||
Complex lookup | Excel Worksheet Functions | |||
Help with complex index array issue | Excel Worksheet Functions |