Index Match (offset) /iferror

[brian sullivan]

I'm reaching to develop the most efficient (Index /Match) formulas in my attached data. I'm looking up individual cells of data from one sheet from another column based sheet.



Formula in Cell
No formula in cell (N2 & O2) . Want to utilize most efficient Index/Match/Offset, or (other) formula combination that delivers a text value (utilizing C2, E2, F2, G2) from Data Sheet


Desired Result
N2 would retrieve value of Apple from data sheet (k7) .
O2 would retrieve value of Good from data sheet (L 7)
Would like to include a blank if data does not match up. I'm guessing that's where if-error comes into play using ""

 

[Chihiro]

Not sure if it is most efficient, but standard format.

=IFERROR(INDEX('Data Sheet'!K$4:K$7,MATCH($C2&$E2&$F2&$G2,'Data Sheet'!$G$4:$G$7&'Data Sheet'!$H$4:$H$7&'Data Sheet'!$I$4:$I$7&'Data Sheet'!$J$4:$J$7,0)),"")

Copy the formula into N2, CSE, and drag and extend to O and down to 8.