View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Roy the plumber[_2_] Roy the plumber[_2_] is offline
external usenet poster
 
Posts: 1
Default vlookup and drop downs

I am making a invoice with 3 or more drop downs for item and the sub type of
item.
Like type of item pipe, type of pipe abs, size of pipe, with different pipe,
sizes, ect to pick from to return a price from items on 2 or more sheets. I
have looked at vlookup and dependent drop downs but I don't know what is
better or how to make the lookup look an more than one sheet with the info in
the 3 drop downs.
Thanks Roy the plumber