VLOOKUP

  • Thread starter Thread starter lindle101
  • Start date Start date
L

lindle101

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.
 
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
 
=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?
 
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 said:
=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 said:
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
Click to expand...
Click to expand...
 
I just needed to sort both spreadhseets by part number and it fixed it.
Thanks for your help!

Mike H said:
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 said:
=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 said:
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

:

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.
Click to expand...
Click to expand...
Click to expand...
 
If you add the 4th parameter to your vlookup, and make it FALSE, then you
don't need to have the table sorted. Since you are specifically looking for
exact matchups, FALSE is recommended :).
=vlookup(c2,'c:\[update.xls]sheet1'!a:b,2,FALSE)


--
John C


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

Mike H said:
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 said:
=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?

:

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

:

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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top