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
Bookmarks