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!!!!!