I've had this problem in the past but have never had time to try and figure it out. While doing a VLOOKUP I get all of my returns to come back "#N/A." However when I look on the sheet I'm referencing they are actually listed. If I click the cell and press enter the VLOOKUP will then return the reference. Does anyone know why this happens?