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 work out, try to make the formulas simple like in Office 2013.
Excel file in this link
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.
1