I want to use a vlookup and if statement to return a value of Y if found and
N if not found i.e. look up the value in column a in another spreadsheet and
put N if not found and Y if found

One alternative is something like this in say, C1::
=IF(ISNUMBER(MATCH(A1,B:B,0)),"Y","N")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Katie" wrote:
I want to use a vlookup and if statement to return a value of Y if found and
N if not found i.e. look up the value in column a in another spreadsheet and
put N if not found and Y if found

=IF(ISNA(VLOOKUP(...)),"N","Y")

The ISNA() function tests if the expression returns #N/A, which is what
VLOOKUP returns when it does not find what it looks up.

HTH
Kostis Vezerides

On Jan 25, 4:20 pm, Katie wrote:
I want to use a vlookup and if statement to return a value of Y if found and
N if not found i.e. look up the value in column a in another spreadsheet and
put N if not found and Y if found