problem with v lookup
 

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

problem with v lookup
 

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

problem with v lookup
 

I think it would be easier to do your lookup from sheet 2, and do
,False
Then set Autofilter and select all the items that are #N/A to be copied
and pasted into Sheet 1

ie, from sheet 2, in a spare column

=Vlookup(A1,Sheet1!A:A,1,False)

will return the contents of sheet 1 for a match, and #N/A for an item
that does not exist on Sheet 1.

Then, on sheet 2, set Autofilter and select the #N/A items, highlight
all of these rows and Copy - then back to Sheet 1, the first available
row, and Paste.
Delete the column which had the #N/A for the rows just inserted.

Does this help?

--

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


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=534486

problem with v lookup
 

Hi toppers,
what I am trying to do is match the information on sheet 1 two sheet 2, the
main problem is that the data is half correct in sheet 1 and the rest is in
sheet 2 so I am trying to duplicate it so that sheet 1 pulls it through from
sheet 2 what is missing and they match it perfectly. hope this makes sense?
Thanks
Elliott
"Toppers" wrote:

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