 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / March 2008VLOOKUP PULLING WRONG DATA
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! >I am using the function shown below. >=VLOOKUP(A3,'C:\Users\Donald\Documents\2008 Estimating Files\[2008 PARTS [quoted text clipped - 15 lines] > >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 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 [quoted text clipped - 26 lines] > > Hope this helps. / Lars-Åke 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 [quoted text clipped - 26 lines] > > Hope this helps. / Lars-Åke 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. [quoted text clipped - 31 lines] > > > > Hope this helps. / Lars-Ã ke  SignatureDave Peterson Try to change TRUE to FALSE > I am using the function shown below. > =VLOOKUP(A3,'C:\Users\Donald\Documents\2008 Estimating Files\[2008 PARTS [quoted text clipped - 15 lines] > > HELP! I will give it a try. Thanks > Try to change TRUE to FALSE > [quoted text clipped - 17 lines] > > > > HELP! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.