hello
New to excel and formulation, as you will see by my questions and sample workbook, right here goes and please forgive bad terminology and spelling
I have been experimenting with data validation, drop down lists, dependent lists all going well just got a little stuck using INDEX and MATCH formula.
I may even be using the wrong formula for what I want to achieve...in the sample workbook I have column A drop down choose from a list of Machine Names,
column B has list of products dependent to specific machine chosen, all data taken from other sheet...my problem is i want to automatically insert into
column C run rate for the product chosen, I have it working but only for one machine which works with below formula, is there any way of modifying it to
point to all the other machine run rates? sorry if I have made mistakes I hope people can understand what I mean when using sample workbook
=INDEX(felixrate,MATCH(B2,Felix,0))
Many thanks
John
Bookmarks