Vlookup

[Zen]

Hi everybody,

I am facing a problem. I have 2 work books. The 1st is masterlist.xls and
the 2nd is source.xls. I want to check under the column "acc no" and "acc
officer" of the masterlist against the source to see if there is any
updates/change in "acc officer"
I tried this formula in the masterlist:

=VLOOKUP("XXX",[Source.xls]Sheet1!A4:E2147,2,FALSE)

But my result is invalid. However it works using another self created
testing work book.

I have 2000 over records to check if there is any change in acc officer. Is
that a better way to check using what functions instead of entering
individual formula?

Pls help and thanks in advance

 

[Roger Govier]

Hi

I am assuming that acc no is numeric.
If that is the case, then what you are looking up should be numeric also
e.g XXX not "XXX".