vlookup and drop downs
 

I am making a invoice with 3 or more drop downs for item and the sub type of
item.
Like type of item pipe, type of pipe abs, size of pipe, with different pipe,
sizes, ect to pick from to return a price from items on 2 or more sheets. I
have looked at vlookup and dependent drop downs but I don't know what is
better or how to make the lookup look an more than one sheet with the info in
the 3 drop downs.
Thanks Roy the plumber

vlookup and drop downs
 

Roy,
Send me sample file
Get my email addy from my website
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Roy the plumber" wrote in message
...
I am making a invoice with 3 or more drop downs for item and the sub type
of
item.
Like type of item pipe, type of pipe abs, size of pipe, with different
pipe,
sizes, ect to pick from to return a price from items on 2 or more sheets.
I
have looked at vlookup and dependent drop downs but I don't know what is
better or how to make the lookup look an more than one sheet with the info
in
the 3 drop downs.
Thanks Roy the plumber