Forum Discussion
Solved
Search product, return Found, Not found or leave blank if no data entered.
I have a file with different product numbers and i'm trying to create a search function that returns a Found, Not Found or Leaves cell blank if no data is entered into the search. Using IF(Vlookup I...
maybe
=IF(A1="","",IFERROR(IF(VLOOKUP(...)<>"","Found"),"Not Found"))
maybe
=IF(A1="","",IFERROR(IF(VLOOKUP(...)<>"","Found"),"Not Found"))
This is it, thank you!
