Multiple Lookup Application

J

JAD

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
 
D

DazzaData

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
 

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

Top