You may look for numeric items which indeed look like numbers and are
formatted as such, but still are text. Format an empty cells as Number.
Enter the number 1. EditCopy.
Select your "numbers" EditPaste special, check Multiply.
Does that help?

If not, post again in this thread, but do give some more information like
your formula, the values you look for, whether the data is sorted or not,
etc.

"Janeen" wrote in message
...
After verifying that the formula is correct, matching cell formats, and
verifying the cell data is an exact match, I continue to get a "N/A"
response
in two cells of my workbook. I've even gone so far as to back out of
Excel,
re-launch the program, and re-open my source file and VLOOKUP file. Out
of
over 1300 matched items, these two refuse to cooperate! Can anyone tell
me
why?

I'm frazzled beyond understanding at this point... (sigh)