Forum Discussion
VLOOKUP anamoly?
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,...
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
Regardless if the trailing 0 is there or not, it still returns the same error:
"The cell currently being evaluated contains a constant."
#heavysigh
DG
