How to Use IF with ISNA & ISBLANK among vlookup

[Rastancu]

Hello guys,

I've hit yet another blocker, I'm trying to create a formula that will say yes if a value is present in the repository and "No" if it's not but at the same time if I have a blank cell I want it to be ignored.

I can't figure out where to add ISBLANK in the following formula : =IF(ISNA(VLOOKUP(A2,'Nr in System'!A:A,1,FALSE)), "No", "Yes")

The reason for this is that I also want to count how many values are present and not, attached you can find the excel sheet.

Thank you !

Best regards,
Razvan

[Fluff13]

How about

Please Login or Register  to view this content.

[Rastancu]

Hello Fluff13 !

Works amazing, thank you !

Best regards,
Razvan

[Fluff13]

You're welcome & thanks for the feedback