How do I solve this problem? Below is my formula:
=IF(ISNA(INDEX(Sheet1!$B$2:$B$296, MATCH(Sheet1!B15, Sheet1!$B$2:$B$296, 0), 1)),"",INDEX(Sheet1!$B$2:$B$296, MATCH(Sheet1!B15, Sheet1!$B$2:$B$296, 0), 1))
There is Data in all of the cells showing the Error. All cells in both sheets are set to...