I am using a drop down box to insure that this is an exact match.

Furthermore, as a method of testing I tried deleting the value in a working
cell and entering a single letter. Then using the drop down list to select
that letter. Same result.

LWhite

"Vacation's Over" wrote in message
...
Since you have selected "FALSE" the #N/A means no "EXACT" match was found

check for trailing spaces in either of your entries

IF so then you may need to use a drop down box to Validate B17 selection