Hi

Can anyone help me with a vlookup I need to do.

I have two excel files. One orders and the other contract.

The contract file contains the contract no in column A, contract ref in column B, The orders file contains contract no in column A, in column B I want to add the contract ref from the other file.

Hope this makes sense.
Thanks for your help
Andy Gill

Try using something like the following in column B of the second file:

      =VLOOKUP(A1,'C:\Directory Path\[Orders.xls]Sheet1'!$A$1:$B$500,2)


      -Phil-

Still answering ancient history posts, I see. And here I thought that *I* answered too many posts.

It's a good answer, though.