Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop downs and look up | Excel Programming | |||
Creating drop downs in a cell contingent on another drop down | Excel Discussion (Misc queries) | |||
drop downs | Excel Discussion (Misc queries) | |||
Vlookup using drop downs and table | Excel Worksheet Functions | |||
Cross-referenced drop-down menu (nested drop-downs?) | Excel Worksheet Functions |