trying to extract column values (type, xxx, yyy, hhh, Ci) based on “W” column value from “Sheet2” table:
Sheet2
Sheet1
I tried some index and match functions, but it didn’t workout, try to make the formulas simple like in Office 2013.
Excel file in this link
thanx in advance.
New contributor
wert trew is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.