So I have workbook with sheets named for each employee in my company, and then have a sheet summarizing the data. In the summary sheet I want to say IF a certain cell in the summary matches a certain cell in the employee sheet, give me 1, if it doesn't give me 0. (I aim to replace the 1 with a hlookup afterwards, however one thing at a time). The current formula I'm using is:
=IF(INDIRECT(B6&"!D26")=E5,1,0) B6 is the employee's name, D26 is a cell in the employee sheet that will either match E5 or won't.
This however returns the #REF! error.
I have also tried:
=IF(INDIRECT("'"&$B6&"'!D26")=E5,1,0)
Which returns the same error.
Does anyone have any ideas?
Bookmarks