Match search terms, and add data in next column. Multi search problem.

**Wales MB** · 01-23-2013, 04:21 PM

What I have is two sheets, 'Template' and 'Sheet2', on template i have a database and in column F a list of names (in example i have it sorted but in the actual it wont be). On Sheet2 in column B there is a list of the names (removing duplicates) used in database, column C holds a code (could be text or number).

What I need is the search list to look at Sheets("sheet1").Range("B:B") and then add the corresponding code from C:C in to the database on Sheets("Template").Range("F:F").

I am banging my head against the wall......

Please Login or Register  to view this content.

Help.xlsm

**stnkynts** · 01-23-2013, 04:49 PM

Edit: Macro not needed. Your post is a little confusing (ie. There is no "Sheet2" in your example, and its not clear what you want to go where) so I will guess. Put this in column F of the "Template" sheet. Copy down.

Please Login or Register  to view this content.

**Wales MB** · 01-23-2013, 05:10 PM

I want to insert the value (this could even be a formula) from column C of sheet "Sheet1" to column G (sorry) of sheet "Template" all based upon the persons name which is in column B and F respectively?

Sorry thought I named it "Sheet2" in my example, it is sheet1

**mike7952** · 01-23-2013, 05:11 PM

This should do it

Please Login or Register  to view this content.

**Wales MB** · 01-23-2013, 05:49 PM

Thank you that works fine...... I don't really understand how it works...... but it does work very well...

I there was a formula in column c on sheet1, could the code be amended to paste the formula??

Originally Posted by mike7952

This should do it

Please Login or Register  to view this content.

**mike7952** · 01-23-2013, 05:53 PM

Wales MB

Please dont quote whole post.

Not sure what your meaning by formulas. Can you post a example?

**Wales MB** · 01-23-2013, 06:10 PM

Sorry about that I pressed the wrong button.....

Not a hundred percent sure, but thinking along the line of a Index and match look up, looking at a different excel file (Each name will need to look at different file), but using search data from the same row but from column D and E (all on sheet Template)......... ???

When the formula gets pasted in it needs to reference the data in the same row.....