are you working with dates?

"Ekazakoff" wrote in message
...
I am getting #N/A errors even when I have an apparently exact match in my
table array to the lookup value. I know that excel requires the formats
to
be exactly the same and I can force the match if I copy the lookup value
from
my table array and paste it into the worksheet. Is there an easy way to
"fix" my table array. The table array is a reference worksheet I have
created which has worked in the past.