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.

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.

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.

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.