Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-13-2015, 08:10 AM
c123456 c123456 is offline Vlookup multiple workbooks Windows 7 64bit Vlookup multiple workbooks Office 2007
Novice
Vlookup multiple workbooks
 
Join Date: Mar 2015
Posts: 2
c123456 is on a distinguished road
Default Vlookup multiple workbooks


Hello all I am fairly new to the more advanced (at least for me) Excel calculations. I am hoping to get some help with the following. I have WorkbookA which has worksheet Activeputaway and in column A there is the employee ID formatted as text and sorted in ascending order. I also have WorkbookB which has a worksheet WMputaway and in column A there is the employee ID formatted as text and it is also sorted in ascending order. Worksheet WMPutaway has a column C which has the total cases. I want to add the total cases to WorkbookA to the Activeputaway worksheet by using VLookup. Here is the formula I have in worksheet Activeputaway=IF(ISERROR(VLOOKUP(A2,[activeputawaytesting03022015Ver1.xls]Sheet1!$A$2:$C$18,3,FALSE)=TRUE),0,(VLOOKUP(,[activeputawaytesting03022015Ver1.xls]Sheet1!$A$2:$C$18,3,FALSE))). But the results are 0 and #NA. It appears that when the IDs match between the worksheets #NA displays and when no match is found the 0 is displayed. What could cause this? Thank you
c123456
Rose
Reply With Quote
  #2  
Old 03-13-2015, 09:11 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Vlookup multiple workbooks Windows 7 64bit Vlookup multiple workbooks Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

Perhaps post a sample sheet ( no pics please) (and try without the =TRUE part first)
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 03-13-2015, 12:50 PM
c123456 c123456 is offline Vlookup multiple workbooks Windows 7 64bit Vlookup multiple workbooks Office 2007
Novice
Vlookup multiple workbooks
 
Join Date: Mar 2015
Posts: 2
c123456 is on a distinguished road
Default Vlookup multiple workbooks

Here is an example of the two workbooks-I hope the formatting is okay.
workbook A/worksheet active putaway:
Emp ID Dept A. ID Dt in In Time Out Time Ttl Amt Rev Time Xfr Val.
Sally 777 2634 99356 3/2/15 8:11 5:15 8.82 8.32 29 132
Ted 553 2634 82175 3/2/15 8:13 5:16 8.78 8.30 29 175


Workbook B/Worksheet WM putaway:
ID User Ttl Ctns Ttl Units
777 Sally 132 1713
553 Ted 175 2346

I want to update Workbook A with the TTL Ctns from Workbook B.
Reply With Quote
  #4  
Old 03-13-2015, 12:59 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Vlookup multiple workbooks Windows 7 64bit Vlookup multiple workbooks Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

Thank you for the example. Please post a sheet, so that we can work on it. Thx
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Vlookup multiple workbooks VLookup multiple values and Sum tinfanide Excel 2 09-02-2014 11:41 AM
excel vlookup with multiple criteria mpokorny Excel 4 05-06-2012 04:06 AM
Vlookup multiple workbooks Vlookup or Index/Match - Multiple Criteria ruci1225 Excel 1 01-15-2012 07:31 AM
Link multiple excel workbooks to publisher bandcsaravia Publisher 0 10-24-2011 09:14 AM
Vlookup multiple workbooks Multiple VLOOKUP's checking multiple Cells OTPM Excel 11 05-23-2011 11:18 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:29 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft