Ok, so I have a lookup table that looks something like this:
Month, 1, 2, 3,...
Altona, 35, 49, 52,...
Bliss, 21, 37, 47,...
...
My function looks like this:
VLOOKUP("Altona",A1:D4,4)
So the value returned should be '52'...but I get #N/A. However, if "Bliss" is the lookup value, the formula...