VLOOKUP

[Guest]

cant.
My B14 & B15 is for same results (those duplicate). You can ignore them.
The problem is how to make the search results fields back to empty or blank
if search is unable to find for the 2nd time.

 

[Dave Peterson]

As far as I understand this, you've gotten several responses that do just that.

I don't know what else to offer.

cant.
My B14 & B15 is for same results (those duplicate). You can ignore them.
The problem is how to make the search results fields back to empty or blank
if search is unable to find for the 2nd time.