v look up and if statement
 

I need a formula that will lok up what is in a cell an another worksheet, and
return "y" if it finds it and "n" if it doesn't

I've tried using an if ststement with a v look up but I can't seem to get it
right

v look up and if statement
 

=IF(ISNA(VLOOKUP(B1,Sheet2!A1:A4,1,FALSE)),"n","y" )

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Katie" wrote in message ...
|I need a formula that will lok up what is in a cell an another worksheet, and
| return "y" if it finds it and "n" if it doesn't
|
| I've tried using an if ststement with a v look up but I can't seem to get it
| right

v look up and if statement
 

More info

--
Don Guillett
SalesAid Software

"Katie" wrote in message
...
I need a formula that will lok up what is in a cell an another worksheet,
and
return "y" if it finds it and "n" if it doesn't

I've tried using an if ststement with a v look up but I can't seem to get
it
right

v look up and if statement
 

=IF(ISERROR(VLOOKUP([your vlookup])),"n","y")

Dave
--
Brevity is the soul of wit.


"Katie" wrote:

I need a formula that will lok up what is in a cell an another worksheet, and
return "y" if it finds it and "n" if it doesn't

I've tried using an if ststement with a v look up but I can't seem to get it
right

v look up and if statement
 

See also responses to your earlier identical posting ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Katie" wrote in message
...
I need a formula that will lok up what is in a cell an another worksheet,
and
return "y" if it finds it and "n" if it doesn't

I've tried using an if ststement with a v look up but I can't seem to get
it
right