I just needed to sort both spreadhseets by part number and it fixed it.
Thanks for your help!

"Mike H" wrote:

Hi,

Your formula works fine for me so if it's returning NA then I would suggest
it's a data issue and it isn't finding a match for C2

Mike

"lindle101" wrote:

=vlookup(c2,'c:\[update.xls]sheet1'!a:b,2)

c2 is where it keeps returning an #N/A and when I review it simply gives the
constant message. It matches an auto part number to the update file in c:\,
and inserts the updated price from that file (at lease what it does on all my
other updates). Any ideas?

"Mike H" wrote:

All Excel is telling you is that the lookup value is a constant which isn't
an issue. What exactly is the problem and why are you having to evaluate your
formula? can we see it?

Mike

"lindle101" wrote:

I am trying to do a vlookup and when I check my calculation steps it says
that 'the cell currently being evaluated contains a constant'. I am not sure
about this error. The first cell contains a 1-438 number in general format.