why is my function greyed out?

[eeps24]

I am using office 365,

My formula is greyed out (screen shot below) Does anyone know why?

Originally I was doing my vlookup as "=VLOOKUP(B:B,'phish training'!A:E,5,FALSE)" but excel stopped me and said "formula you have entered may spill beyond the edges of the worksheet" and asked me if I wanted to do this instead "=VLOOKUP(@B:B,'phish training'!A:E,5,)". If I say no, then it gives me a #spill error.

If I say yes then it adds a "@" to my column. =VLOOKUP(@B:B,'phish training'!A:E,5,). Whats the @ for?




Capture.JPG

[Fluff13]

That is because the formula has "Spilled" only the 1st cell with the formula will be editable all other cells will be greyed out.
Assuming the formula is in row 2 use

Please Login or Register  to view this content.

then you can copy it down as far as needed.