lookup drop down

[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. 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