MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Merging data from two sheets, then merging data on one sheet


Posted by JAMES T on February 01, 2002 4:42 PM

Hi, First Post,

PLEASE HELP ME

This is what am trying to do.
Have two work sheets.
Example:
SHEET 1
A B
Part # 1 IMPORTANT COMMENTS
Part # 2 IMPORTANT COMMENTS

SHEET 2
A B
PART #1 MISC NOTES
OTHER INFO multiple rows MISC NOTES
PART # 2 MISC NOTES
OTHER INFO multiple rows MISC NOTES

INSIDE SHEET 2 NEED TO GET IMPORTANT COMMENTS FROM SHEET 1 INTO COLUMN "C" ON SHEET 2


Posted by Barrie Davidson on February 01, 2002 6:37 PM

Try using the VLOOKUP function. Have a look at:

http://ca.geocities.com/b_davidso/Web_Page_Files/Excel/lookup.html#VLOOK

for an explanation of the syntax required.

Hope I've helped you out :)

BarrieBarrie Davidson

Posted by James T on February 01, 2002 7:05 PM

Barrie

Thanks, still struggling

But I need it to find the matching part number on sheet 1, get the comments for that part number, and add that comment for that part number onto sheet 2 in the comment field, (column c). For each part number.

Thanks

Posted by Barrie Davidson on February 01, 2002 7:17 PM

Okay, let's assume your part numbers on sheet 1 are in the range A1:B2000. Put this formula in C1 and copy down:

=VLOOKUP(A1,Sheet1!$A$1:$B$2000,2,0)

How's that?
BarrieBarrie Davidson

Posted by James taylor on February 02, 2002 6:01 AM

Thanks, That worked Great


Barrie,

Thanks

That worked GREAT,

Your a very nice Man,

God Bless You,

Thanks again,

James