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

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