I'm usually pretty good with formulas but my minds drawing a blank on this one. I've tried googling but either I'm not articulating what I need clearly or no-one else has asked the question before (I suspect the former!).
I have a range of cells, lets say B5:B10, that I want to search. That range may contain the value "UK", "Intl" or be blank.
I'd like a formula to search the range and if it only finds UK, return UK, if only Intl, return Intl - or if both UK and Intl then return UK / Intl.
Sounds simple enough but just not sure which formula would be best to use - vLookup, match...?
Being a bit dim... TC