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 General Formatting, because when I formatted them as text the formula didnt work. Any ideas?? Thanks,
![Confused :confused: :confused:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
![Confused :confused: :confused:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
![Confused :confused: :confused:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
=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 General Formatting, because when I formatted them as text the formula didnt work. Any ideas?? Thanks,