VLOOKUP
 

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.

VLOOKUP
 

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.

VLOOKUP
 

=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.

VLOOKUP
 

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.

VLOOKUP
 

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.

VLOOKUP
 

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" wrote:

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.