Vlookup Help - Yes and No

[djmnon]

I have created a Vlookup formula on one of the columns on a workbook. This Vlookup will look for part numbers on the other Workbook and paste the ones that are matching and others that are not matching will showup as NA

I want to change this formula in a way that. Anything that Matches should be tagged as Yes and Anything else will be No. How can I change this formula

=VLOOKUP(B2,'CDM MyPart List 31Mar2022.xlsx'!Table2[#All],1,FALSE)

Please help

 

[Fluff]

How about

=IF(ISNA(VLOOKUP(B2,'CDM MyPart List 31Mar2022.xlsx'!Table2[#All],1,FALSE)),"No","Yes")

 

[Phuoc]

Try this:

=IF(SUMPRODUCT(--(B2='CDM MyPart List 31Mar2022.xlsx'!Table2[#All])),"Yes","No")

or:

=IF(COUNTIF('CDM MyPart List 31Mar2022.xlsx'!Table2[#All],B2),"Yes","No")

.

 

[djmnon]

How about

=IF(ISNA(VLOOKUP(B2,'CDM MyPart List 31Mar2022.xlsx'!Table2[#All],1,FALSE)),"No","Yes")

Thanks really helps

 

[djmnon]

Try this:

=IF(SUMPRODUCT(--(B2='CDM MyPart List 31Mar2022.xlsx'!Table2[#All])),"Yes","No")

or:

=IF(COUNTIF('CDM MyPart List 31Mar2022.xlsx'!Table2[#All],B2),"Yes","No")

.

Superb...Thanks a ton

 

[Fluff]

Glad we could help & thanks for the feedback.