Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Lookup Application
I have a speadsheet in which I am selecting a metal pipe based on two inputs.
The first input would be the pipe size (1", 2", 3", 4", 6", 10", etc). The second input would further refine the selection as to the pipe schedule (Sch 10, Sch 20, Sch 40, Sch 80, etc). Is it possible to do a lookup on the pipe size and then do a second lookup on the pipe schedule? Or is there a better way of achieving the same results? Any help would be appreciated. Thank You, JAD |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Lookup Application
I would recommend creating another column where you concatenate all of the
search criteria into one string possibly with a separator if required i.e. A1&"_"a2&"_"&A3 Then use the same principle when adding together the criteria you want the lookup to find. Hope this helps Cheers "JAD" wrote: I have a speadsheet in which I am selecting a metal pipe based on two inputs. The first input would be the pipe size (1", 2", 3", 4", 6", 10", etc). The second input would further refine the selection as to the pipe schedule (Sch 10, Sch 20, Sch 40, Sch 80, etc). Is it possible to do a lookup on the pipe size and then do a second lookup on the pipe schedule? Or is there a better way of achieving the same results? Any help would be appreciated. Thank You, JAD |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Lookup Application
Take a look at this:
http://img513.imageshack.us/img513/2525/lookupxxlb1.jpg Biff "JAD" wrote in message ... I have a speadsheet in which I am selecting a metal pipe based on two inputs. The first input would be the pipe size (1", 2", 3", 4", 6", 10", etc). The second input would further refine the selection as to the pipe schedule (Sch 10, Sch 20, Sch 40, Sch 80, etc). Is it possible to do a lookup on the pipe size and then do a second lookup on the pipe schedule? Or is there a better way of achieving the same results? Any help would be appreciated. Thank You, JAD |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup/multiple | Excel Worksheet Functions | |||
Lookup using multiple sheets and multiple criteria, sorry if 2 pos | Excel Worksheet Functions | |||
Lookup using multiple sheets and multiple criteria | Excel Discussion (Misc queries) | |||
Lookup in Multiple Columns, Return Multiple Values | Excel Worksheet Functions | |||
Multiple Application.UserNames | Excel Discussion (Misc queries) |