IF statement referencing the result of a VLOOKUP

[awskit89]

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

 

[Fluff]

Hi & welcome to MrExcel.
The Y & N need to be wrapped in Quotes

 

[awskit89]

Thanks

 

[Fluff]

You're welcome