You're welcome - thanks for feeding back.

Pete

"empire11" wrote in message
...
Yep...that works. I've only ever used lookups where I'm looking for the
exact number so alway put =VLOOKUP(A1,M1:N5,2,FALSE) so that it would
return
an #N/A if it couldn't find an exact match. All sorts of possibilities
now...thanks Pete!