Formula to search range for either or both values, ignoring blanks

Hi,

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

Thanks for your reply Sambo Kid - if statement would work for just one cell as you say, but I need one formula to search a Range B5:B10...

Thanks Ace_XL and alansidman, both of these work nicely!