Hi Gurus,

I am not sure if this is completed by a formula or VBA, but I think a formula would work.

Column A
RIM*RT 123456
RIM*RS 654321
RIM*RW TestName

The above example is in the named range (Text), the whole values sit in column A. I need a formula that will look at the named range and if it finds RIM*RS return 654321. I have a lot of cells in Column A, so just a bunch of ifs, will not work. I would like one formula I could put in cell D1, that would return the 654321,if the criteria is met. Then have it look for RIM*RT in say cell E1. Please let me know if you need a better explanation.

Thanks in advance.