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

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

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.

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