View Single Post
  #43   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] lhkittle@comcast.net is offline
external usenet poster
 
Posts: 168
Default Drop Downs, Index Match or what?


please look he

https://skydrive.live.com/#cid=9378A...121822A3%21326

for workbook "Copper"
Regards


Claus B.


That works, as of course you already know.

The REVERSE Drop Down workbook was quite easy to add additional Materials.
And I noticed in the dependent DV drop down "refers to" Indirect formula using substitute so one is not bothered with spaces in the range names.

I think all is good to go, I thank you and sorry for all the spoon feeding I needed.

Regards,
Howard