View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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