Vlookup: very Simple lookup, but need help. Not working

[azzi2000]

I have 2 excel sheets:
Sheet1: Y/N,item,price,code,desc...
Sheet2: item

All I want to do is compare sheet1 to sheet2 and have Y-yes found and n-Not found in Sheet1

Please help
Dré

 

[SkipVought]

Hi,

[tt]
=if(iserror(match(Sheet2!Item,Sheet1!Item,0)),"N","Y")
[/tt]
where

Sheet2!Item is the reference to a single cell contaiing an item value and

Sheet1!Item is the reference to the item range



Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}

 

[AnotherHiggins]

azzi2000,

Try this:
[COLOR=blue white]=IF(ISNA(MATCH(B2,Sheet2!$A$2:$A$6,0)),"N","Y")[/color]
Copy down column A as far as needed.

[tt]_____
[blue]-John[/blue]
[/tt][red]"If you're flammable and have legs, you are never blocking a fire exit."[/red]
-Mitch Hedberg

Help us help you. Please read FAQ181-2886 before posting.

 

[AnotherHiggins]

Beat to the punch again, I see.

[tt]_____
[blue]-John[/blue]
[/tt][red]"If you're flammable and have legs, you are never blocking a fire exit."[/red]
-Mitch Hedberg

Help us help you. Please read FAQ181-2886 before posting.

 

[azzi2000]

Thank you.
I was able to do this and it worked:
=Vlookup(B2,Sheet2!$A$2:$A$6,0,False)
Dré