How can a VLOOKUP work fine in one column (C) of my worksheet but returns a #REF! error in another(F)? Using data from another sheet in the workbook, I compile a monthly report for billing. However, recently the formula is failing. The original spreadsheet was done in Excel 2010, but is now in Excel 2016.
Hello! It looks good, but the vlookups look weird without the missing fourth argument in both functions. Try to add a 0 (zero) for exactly searching or a 1 for stepwise searching. In your first =VLOOKUP(A6,webdata!$A$2:$B$122,2,0). Hope that helps, Greets, Eva