On Thu, 27 Mar 2008 16:29:00 -0700, DKPHELP
wrote:

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