What am I missing? Vlookup Formula does nothing.

[Bobbo Jones]

Hi guys, here is my problem.

formula is going in column V
I am trying to match a file name in column U, with a file name in another sheet column B.
Once it has made the match, I need it to look one cell to the right from the found match,
and return what is in column C to the original sheet column V

here is the formula I am using
=VLOOKUP(U2,Sheet1!B:C,2,0)

The strange thing is that this formula worked perfectly 1 month ago. I get back from the Christmas break and it is not working.
Is there a problem with my formula, or have I got a setting on excel switched off somewhere??

thanks for your time
Bobbo

[martindwilson]

have you set calculation to manual somehow in excel options? what happens if you hit f9
incidentally
=VLOOKUP(U2,Sheet1!B:C,2,false) is the correct syntax but you can use 0

[Bobbo Jones]

Ah crap it was just the column was formatted to text. I thought I had checked that. Sorry to waste your time!