VLOOKUP & IF

[Lmurraz]

I am trying to transfer partial information from one spreadsheet to another.
I have one spreadsheet that has a closing date and another where I need to
know only whether there is one or not and not the actual date.

I have tried VLOOKUP combined with IF but I do not appear to be getting the
syntax right - the best I can get is the word " FALSE " appearing if a date
exists in the appropriate cell.

The main formula I am currently using is
=VLOOKUP(A24,'Y:\cove'$1:$65536,8,FALSE)+IF(isblank,"","Y").

Can anyone help?

 

[Don Guillett]

try this idea
=IF(VLOOKUP(4,A4:B9,1,0),"Y","")

 

[Lmurraz]

Wonderful. I thought I was probably overcomplicating it.

Thank-you

 

[Don Guillett]

Glad to help