I sent a file to a colleague that has several vlookups in it so that she
could adapt it for her reports. For some reason the vlookup has stopped
working (it was OK when she first started changing values). For example, the
first vlookup is =VLOOKUP(U4,'Audit tool'!$C$1:$F$514,2,0). In cell U4 is the
text 1.1, and the vlookup returns the value appropriate from the audit tool
sheet. In the next row is 1.2 and so on. If I change cell U4 to 1.2, it
returns #NA, and if I retype 1.1 it still won't return a value. I opened
another spreadsheet with lookups in and the same things happens.

I know the values are correct, no blanks, the vlookup string is correct, I
even checked the tools ... options...calculations and its set to automatic.
Can anyone suggest what is happening? I can only assume it is something from
my colleague's set up / computer that has maybe corrupted this file and is
also causing my lookups (including the original one I sent her) to fail. I
tried rebooting too and that didn't help either! I have tried recreating the
lookups in a new file and they still won't work.

HELP!!

Kate