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