If there is a match using Vlookup Return Found, Otherwise Not Found

[Howardc1001]

I have the following Vlookup formula

Please Login or Register  to view this content.

I would like this amend, so that where there is a match i.e item found, to return "Found" , otherwise return "Not Found"


It would be appreciated if someone could amend my formula

[AskMeAboutExcel]

may be simpler to use an IF/COUNTIF formula e.g.

=IF( COUNTIF( range, search_criteria ) >=1, "Found", "Not Found")

[Sam Capricci]

try this...
=IF(IFERROR(VLOOKUP(B2,'[Items delivered.xlsm]Imported Data'!$A:$A,1,FALSE),"")="","Not Found","Found")
untested of course.

[Howardc1001]

Thanks for the help Guys