Hi
From a previous thread (sorry I cannot locate it now) I have borrowed a function similar to this =IF(ISNUMBER(SEARCH("SU",BK5)),"Special User"

I am trying to see if cells contains SU the target cell is populated with Special user. I have also combined these into a series of if statements successfully to look for other conditions.

=IF(ISNUMBER(SEARCH("SU",BK5)),"Special User",IF(ISNUMBER(SEARCH("p",BK5)),"Prof user",IF(ISNUMBER(SEARCH("LP",BK5)),"Limited Prof user","")))

However I now need to apply this to a range of cells not just BK5. I have tried this with a valid number range by using BK1:BK5 but it returns no error or results even though BK5 is populated with a "p".

I would very much appreciate suggested resolution......

Thanks
Si