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 [email protected] and I will forward you
the example.

Regards,
Howard
 
Top