HI,
is it possible to get an xlookup to give you results as normal EXCEPT if the result contains a keyword listed in another cell to instead return a blank cell? I am trying to run xlookups but using keywords as an exclusion criteria.
My xlookup formula so far is:
=xlookup(E2&$I$1,'Raw data'!G:G,'Raw data'!B:B) and I want it to give a blank result if the xlookup result contains text found in G2, but if the xlookup result does not contain text in G2 then to show the result
i.e. if my xlookup result is CAT when CAT is excluded (as listed in G2) then give blank cell, byt if my xlookup result was DOG then DOG would successfully be shown
Any help much appreciated
Bookmarks