copying data between sheets

I need to copy information from one sheet to another if it meets a criteria.

If the text in column C sheet two has a match in column G sheet one return the text that is in column C sheet 1 that is related to the match.

Is this possible?

Hi,

Yes, this can be done using VLOOKUP or INDEX/MATCH functions. Please post a sample template in excel format if you need further help!

Template.xlsx

I Have attached a template

Hi,

Try the following Array formula in E3 (Sheet2):

{=INDEX(Sheet1!$B$2:$G$6,MATCH($C3&$D3,Sheet1!$G$2:$G$6&Sheet1!$B$2:$B$6,0),2)}

Please note that this formula needs to be confirmed by pressing CTRL+SHIFT+ENTER

Thank you

As stainless steel is used in three different parts is there any way for all three part numbers to be displayed?

Hi,

Try the following array formula in Sheet2, E3:

{=IFERROR(INDEX(Sheet1!$B$2:$G$6,SMALL(IF(COUNTIF($D3,Sheet1!$B$2:$B$6)*COUNTIF($C3,Sheet1!$G$2:$G$6),ROW(Sheet1!$B$2:$G$6)-MIN(ROW(Sheet1!$B$2:$G$6))+1),COLUMN(A1)),ROW(B$2)),"")}

to be confirmed by pressing CTRL+SHIFT+ENTER

works brilliantly thank you

You are welcome

If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved.