Hi,
I am attempting to use the result of a VLOOKUP within the logical test of an IF statement, however I am getting a #NAME ? error. It's probably something simple but I have not managed to solve the issue with over an hour of Googling
Cell AE29: =VLOOKUP(B29,'EMIS Report'!$A$1:$E$72,5,FALSE)
Result: Complete
IF statement: =IF(AE29="Complete",Y,N)
Any help would be much appreciated.
Thanks
I am attempting to use the result of a VLOOKUP within the logical test of an IF statement, however I am getting a #NAME ? error. It's probably something simple but I have not managed to solve the issue with over an hour of Googling

Cell AE29: =VLOOKUP(B29,'EMIS Report'!$A$1:$E$72,5,FALSE)
Result: Complete
IF statement: =IF(AE29="Complete",Y,N)
Any help would be much appreciated.
Thanks