Please refer to the spreadsheet.
My objective is to use index small function to return nth value, but at the same time search for cell that contain a certain value "SOP 6001" Cell D6.
For example, i have successfully created the search index small function in Cell B11 to B13 to return result of "Mercury", "Ether", "Ethanol respectively, from cell V1 to V3 based on the search in Cell W11 to W13.
However i have trouble getting "NaOH" to be reflected in Cell A4 since it cant recognize the value from Cell W14.
What will be a suitable formula to achieve my objective?
Thank you.
Bookmarks