Thanks for getting me started - getting an error with this formula - probably
something silly - late in the day.

=IF(ISNA(MATCH ("POS*",B$83:B$782,0)),"", MATCH "POS*",B$83:B$782,0),"Please
be advised the POS LOBs have been converted to PPO LOBs", "")

"Anne Troy" wrote:

Sorry...
=If(ISNA(MATCH("POS*",B$83:B$782,0)),"",MATCH("POS *",B$83:B$782,0),"Please
be advised the POS LOBs have been converted to PPO LOBs", "")

************
Anne Troy
www.OfficeArticles.com

"SharonP." wrote in message
...
Hi, I'm using the following formula. The problem is that sometimes
my value isn't found and I'm not getting a blank but rather #N/A.

=IF(MATCH("POS*",B$83:B$782,0),"Please be advised the POS LOBs have been
converted to PPO LOBs", "")

1. Is there a fix to my formula? or
2. In the cell that results #N/A - I could set a conditional format to
make
a white background and white font. However, when I try that - it's not
working either.

Cell format = #N/A doesn't do what I want.