Frances,

Use VLOOKUP instead of LOOKUP. This gives you the ability to control what Excel returns to you (instead of always getting the closest value). Try the formula below:

=IF(ISERROR(VLOOKUP(B25,'MO Add&Counter'!$E:$H,4,FALSE)),"No Match",VLOOKUP(B25,'MO Add&Counter'!$E:$H,4,FALSE))

where B25 is your target value, the next argument is the full address of the table you are searching, the 4 is the column number within that table that contains the desired result, and "FALSE" tells Excel not to return the closest value, but to report an error instead. You then wrap this in an "ISERROR" function to return the desired message.

Knightly