Quote Originally Posted by FDibbins View Post
Are you sure there is actually something to find on the other file?
If you know that teh data inhe other file really is there, check for leading/trailing spaces in the "found" cell
Yes there is data within the range of the VLOOKUP, and on the correct sheet (Sheet1), I should note that whenever I double click the formula and then enter out, it brings up the "Update Values:DigikeyRateReview_01122016.xlsx" box, and when I double click the file again in this box it just goes back to #N/A