VLOOKUP PULLING WRONG DATA

[DKPHELP]

I am using the function shown below.
=VLOOKUP(A3,'C:\Users\Donald\Documents\2008 Estimating Files\[2008 PARTS
PRICE BOOK.xls]Parts List'!$A:$F,2,TRUE)

In my first spreadsheet (2008 PARTS PRICE BOOK) Column A has a part number
such as E1 or B12. Column B has a part description.
In the second spreadsheet, if I enter E1 in cloumn A it moves the
description for that part to Column B in the second spreadsheet.

I am getting some of my entrys bringing over the wrong data from the first
spreadsheet, even though the formula is correct.

Example:
E1 is Part X in the first spreadsheet.
When I Enter E1 in the second, it gives the part description for part E295.
If I replace E1 with a number such as 89, and type part 89 in the second
spreadsheet the proper description comes over.

HELP!

 

[Lars-Åke Aspelin]

I am using the function shown below.
=VLOOKUP(A3,'C:\Users\Donald\Documents\2008 Estimating Files\[2008 PARTS
PRICE BOOK.xls]Parts List'!$A:$F,2,TRUE)

In my first spreadsheet (2008 PARTS PRICE BOOK) Column A has a part number
such as E1 or B12. Column B has a part description.
In the second spreadsheet, if I enter E1 in cloumn A it moves the
description for that part to Column B in the second spreadsheet.

I am getting some of my entrys bringing over the wrong data from the first
spreadsheet, even though the formula is correct.

Example:
E1 is Part X in the first spreadsheet.
When I Enter E1 in the second, it gives the part description for part E295.
If I replace E1 with a number such as 89, and type part 89 in the second
spreadsheet the proper description comes over.

HELP!

From the help for VLOOKUP:

"If range_lookup is either TRUE or is omitted, the values in the first
column of table_array must be placed in ascending sort order;
otherwise, VLOOKUP might not return the correct value."

Are you sure that your part numbers are listed in ascending order?
If not, try changing TRUE to FALSE in the formula.

Hope this helps. / Lars-Åke

 

[akphidelt]

Try to change TRUE to FALSE

 

[DKPHELP]

They are in ascending order IE: a1,a2,b1,b2 etc.
I have used this formula befor with no problem, but there were no prefix
letters, I only used numbers for the parts.
I will try your suggestions...thanks

I am using the function shown below.
=VLOOKUP(A3,'C:\Users\Donald\Documents\2008 Estimating Files\[2008 PARTS
PRICE BOOK.xls]Parts List'!$A:$F,2,TRUE)

In my first spreadsheet (2008 PARTS PRICE BOOK) Column A has a part number
such as E1 or B12. Column B has a part description.
In the second spreadsheet, if I enter E1 in cloumn A it moves the
description for that part to Column B in the second spreadsheet.

I am getting some of my entrys bringing over the wrong data from the first
spreadsheet, even though the formula is correct.

Example:
E1 is Part X in the first spreadsheet.
When I Enter E1 in the second, it gives the part description for part E295.
If I replace E1 with a number such as 89, and type part 89 in the second
spreadsheet the proper description comes over.

HELP!

From the help for VLOOKUP:

"If range_lookup is either TRUE or is omitted, the values in the first
column of table_array must be placed in ascending sort order;
otherwise, VLOOKUP might not return the correct value."

Are you sure that your part numbers are listed in ascending order?
If not, try changing TRUE to FALSE in the formula.

Hope this helps. / Lars-Ã…ke

 

[DKPHELP]

I will give it a try.
Thanks

Try to change TRUE to FALSE

I am using the function shown below.
=VLOOKUP(A3,'C:\Users\Donald\Documents\2008 Estimating Files\[2008 PARTS
PRICE BOOK.xls]Parts List'!$A:$F,2,TRUE)

In my first spreadsheet (2008 PARTS PRICE BOOK) Column A has a part number
such as E1 or B12. Column B has a part description.
In the second spreadsheet, if I enter E1 in cloumn A it moves the
description for that part to Column B in the second spreadsheet.

I am getting some of my entrys bringing over the wrong data from the first
spreadsheet, even though the formula is correct.

Example:
E1 is Part X in the first spreadsheet.
When I Enter E1 in the second, it gives the part description for part E295.
If I replace E1 with a number such as 89, and type part 89 in the second
spreadsheet the proper description comes over.

HELP!

 

[DKPHELP]

I changed to false, it works better but some #'s still do not work, the carry
over the wrong cell.

I am using the function shown below.
=VLOOKUP(A3,'C:\Users\Donald\Documents\2008 Estimating Files\[2008 PARTS
PRICE BOOK.xls]Parts List'!$A:$F,2,TRUE)

In my first spreadsheet (2008 PARTS PRICE BOOK) Column A has a part number
such as E1 or B12. Column B has a part description.
In the second spreadsheet, if I enter E1 in cloumn A it moves the
description for that part to Column B in the second spreadsheet.

I am getting some of my entrys bringing over the wrong data from the first
spreadsheet, even though the formula is correct.

Example:
E1 is Part X in the first spreadsheet.
When I Enter E1 in the second, it gives the part description for part E295.
If I replace E1 with a number such as 89, and type part 89 in the second
spreadsheet the proper description comes over.

HELP!

From the help for VLOOKUP:

"If range_lookup is either TRUE or is omitted, the values in the first
column of table_array must be placed in ascending sort order;
otherwise, VLOOKUP might not return the correct value."

Are you sure that your part numbers are listed in ascending order?
If not, try changing TRUE to FALSE in the formula.

Hope this helps. / Lars-Ã…ke

 

[Dave Peterson]

Make sure that you have calculation set to automatic.

With that 4th parameter set to false, the =vlookup() is looking for the first
exact match.

If you're getting the wrong value returned (after changing to automatic recalc),
what's in A3?

Do you have wildcards (*, ?) in the cell.

Just to add...
If the =vlookup() can't find find an exact match, then you'll see an error.

I changed to false, it works better but some #'s still do not work, the carry
over the wrong cell.

I am using the function shown below.
=VLOOKUP(A3,'C:\Users\Donald\Documents\2008 Estimating Files\[2008 PARTS
PRICE BOOK.xls]Parts List'!$A:$F,2,TRUE)

In my first spreadsheet (2008 PARTS PRICE BOOK) Column A has a part number
such as E1 or B12. Column B has a part description.
In the second spreadsheet, if I enter E1 in cloumn A it moves the
description for that part to Column B in the second spreadsheet.

I am getting some of my entrys bringing over the wrong data from the first
spreadsheet, even though the formula is correct.

Example:
E1 is Part X in the first spreadsheet.
When I Enter E1 in the second, it gives the part description for part E295.
If I replace E1 with a number such as 89, and type part 89 in the second
spreadsheet the proper description comes over.

HELP!

From the help for VLOOKUP:

"If range_lookup is either TRUE or is omitted, the values in the first
column of table_array must be placed in ascending sort order;
otherwise, VLOOKUP might not return the correct value."

Are you sure that your part numbers are listed in ascending order?
If not, try changing TRUE to FALSE in the formula.

Hope this helps. / Lars-Ã…ke