Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
lookup drop down
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
lookup drop down
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 and I will forward you the example. Regards, Howard "Roy the plumber" <Roy the wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
use v lookup from a drop down list | Excel Worksheet Functions | |||
Drop Down & V Lookup | Excel Worksheet Functions | |||
Drop-down box lookup? | Excel Worksheet Functions | |||
Lookup cross Drop down/scroll box | Excel Worksheet Functions | |||
Using a drop-down list to lookup | Excel Programming |