But isn't that what you wanted displayed?

Re your line:
.. i need to be able to search both those cells
for "ABC" and "DEF" and if it appears,
display it in a different cell.

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"natek1234" wrote in message
ups.com...
i tried that but all i am getting in B2 is "ABC" ; any thoughts?