I have a spreadsheet I must compile information from multiple other workbooks to get the information I need. I have tried using the VLOOKUP function without success. =VLOOKUP(K2,DeptID,13,FALSE). I receive a #NA error. Can someone please help me figure this out?