Forum Discussion
Vlookup
I have created a Vlookup formula - VLOOKUP(A5,ETB!$A$9:$L$105,12), which returns the correct value, but when I copy it down it correctly becomes VLOOKUP(A6,ETB!$A$9:$L$105,12), but then returns the s...
Please ensure calculations are set to automatic. Formulas menu | Calculation | Calculation Options | Automatic.
Thanks, Patrick, yes it is, and all other formulae on sheet are behaving perfectly!