Hello,

I am currently running into an issue with an index/match formula. I have a drop down menu that refers to the titles of columns D:G. Once the selection is made on the menu, the corresponding value under the selected title is reflected in column J. This menu works for all titles except "3 Op" in which it returns #N/A.

After reviewing the calculation steps, I still do not understand the reason for an error. Attached is the spreadsheet. Thoughts?

Assembly_TAKT.xlsx

Thanks!