Copying values in cell based on a number/identifier in excel

[jyym27]

Hello,
I'm working on an excel file and need to copy several values from different cell in the same row to another sheet based on unique number/identifier. As you can see on the attached image several cells (not all) from the row with code 312 will go to sheet "for 312" and respectively for the code 310 (see image #1). I want to make all the changes made on the master will be replicated on the other sheets as well so it has to be a function

I could get multiple row with the IF function (see image #2). But I still get the "not matched"/ 0 0 0 0 values. The function I use is =IF(master!$C2=312,VLOOKUP(C9,master!$C2:$G$14,2,FALSE),0) which then I copied down the rows

Thanks for any help

image #1

image #2

 

[alansidman]

Crossposted: Copying multiple values in cells based on a number/identifier in excel
and
Copying values in cells based on a number/identifier in excel

 

[jyym27]

Crossposted: Copying multiple values in cells based on a number/identifier in excel
and
Copying values in cells based on a number/identifier in excel

Sorry for that, I didn't know if this is prohibited.

 

[jyym27]

crossposted at:


http://www.mrexcel.com/forum/excel-...ased-number-identifier-excel.html#post4663865
Copying values in cell based on a number/identifier in excell
excel - Copying values in cell based on a number/identifier in excell - Stack Overflow
Copying multiple values in cells based on a number/identifier in excel


The reaseon I crosspost was because I need some help quick. I will make update and share the solution here once I got the answer.

 

[Joe4]

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule #13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.