I am guessing that you want to look at column A in Sheet1 and match with $A$1
(from Sheet2?) and return the value in Column B from Sheet1? (The data in
Sheet1 is in rows 1 to 100)

=VLOOKUP($A$1,SHEET1!$A$1:$B$100,2,0)

I not sure I fully understand the problem so the above may be incorrect.

HTH anyway.

"Elliott" wrote:

Hi
i am having an issue with Excel where I have 2 work books with the same
information on both, but bits of data missing I am trying to merge them as
one huge document; so were I have sheet 1 below looking like this
cell A BN55VRP cell B BN55VRP cell Q 1984
I need to make colum A & B to be primary Keys or point of references so that
when I merge sheet 2 to sheet 1 they match i dentically. I was using v lookup
formula but this is not working formula A2,=VLOOKUP($A$1,SHEET1!:$B$100,2,0)
then the same fomula for sheet 2 but changing A3 except changing to sheet 2!
instead of sheet one. Can some one help please this is driving me mad!!!!!