VLOOKUP PULLING WRONG DATA
I will give it a try.
Thanks
"akphidelt" wrote:
Try to change TRUE to FALSE
"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!
|