Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |