Success finally! Thanks everyone for the guidance in putting this formula
together.

"Domenic" wrote:

Try...

=IF(ISNUMBER(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")

Hope this helps!

In article ,
"SharonP." wrote:

My snytax is still incorrect - I'm getting the error -
"You've entered too many arguments for this function".
The following is a cut and paste of my formula -

=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")

This formula looks right to me. Excel frustrates me so bad some days!