vlookup and drop downs

  • Thread starter Roy the plumber
  • Start date
R

Roy the plumber

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
 

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

Similar Threads

lookup drop down 1
Convert code to lookup three criteria return fourth 15
Macros using drop downs 3
Hide rows using VBA based on cell value 0
Purchase Order with Drop downs that will Auto fill typical informa 1
Protected sheets and Drop Downs 1
How to return a range of values in a drop-down. 7
Conditional data validation drop downs 2

Top