Forum Discussion
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 can get the product to return in the result box, but I want it to say Found or Not Found
Using a different Iferror(If(Vlookup I can get a non-found result to return correctly, but it doesn't show blank when nothing is entered in the search box. It'll also return false if Product is found, so I know i'm doing something wrong with that formula.
Top box is what I currently have, bottom box is how I want it to be.
| Enter Product Number | Result |
| WA10649 | WA10649 |
| WA111577 | Not Found |
| Not Found | |
| Enter Product Number | Result |
| WA10649 | Found |
| WA111577 | Not Found |
maybe
=IF(A1="","",IFERROR(IF(VLOOKUP(...)<>"","Found"),"Not Found"))
2 Replies
maybe
=IF(A1="","",IFERROR(IF(VLOOKUP(...)<>"","Found"),"Not Found"))
This is it, thank you!
