GoogleSheets: IfVlookup on different sheet - with result of Y

[Asdf99]

Hi

Please help and tell me how to crawl from sheet 1 to sheet 2 (colomn B) but showing 'Y' when if there keyword data is available in sheet 1 colomn A, while in sheet 2 colomn B should be blank if it's not available.

[AliGW]

Is this for Excel or Google Sheets?

Try this:

=IF(ISNA(MATCH(A2,Sheet1!$A$2:$A$9,0)),"","Y")

[Gatti]

Hello!

=IF(COUNTIF(Sheet1!A:A,A2)=0,"","Y")

[Asdf99]

Hello!

=IF(COUNTIF(Sheet1!A:A,A2)=0,"","Y")

Thank you, but it did not worked, may be caused I am using google excel sheet, please help me with google excel.

Thanks

[AliGW]

I will move this thread. Please post in the CORRECT SECTION next time.

"It is not working" is of no help to anybody: in what way is it not working? I can assure you that both solutions offered DO work for Excel (which is what we've used because you failed to say that this needed to be for Google Sheets).

[Asdf99]

It is giving blank, whereas it should not be giving out blank... please send me excel sheet to re-ensure

[AliGW]

No, it isn't, so you've done something wrong again. See attached.

[Asdf99]

No, it isn't, so you've done something wrong again. See attached.

yes again my bad, thank you very much you are very good in this...