lookup drop down

  • Thread starter Roy the plumber
  • Start date
R

Roy the plumber

I am making a invoice sheet. With materials on two or more sheets. Materials
are plumbing supplies like 2" ABS 90 and 2" ABS coupling with prices the
materials, size, type will all be different. I would like to have 3 or more
drop downs to pick material, size, and type to get to price. I have looked at
vlookup, validation, and dependent drop downs. But I can't figure out what is
the best and how to pull info from more than 2 drop downs
Thank Roy
 
L

L. Howard Kittle

Hi Roy,

I have a workbook example that pretty much does that. Would of course need
to be adjusted to your data layout and such.

If you want, send me an email to (e-mail address removed) and I will forward you
the example.

Regards,
Howard
 

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

vlookup and drop downs 1
Word VBA - Auto Populate Text on Dependent Drop Down Exit 1
How to: Create Dependent Drop Down in a Form 2
referencing a Drop Down Menu 1
Assigning numeric value to text in drop-down menu 1
Pick from drop-down list gives empty or erroneous result 6
drop box/data validation help 0
Need help referencing b/w sheets for school project 0

Top