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

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) . Maybe this is not the best way to do this. Any input and help will be very much appreciated Thank you

#image 1
2uuYemYMBFDKkScjJdKZ1totFkj36nT01YuxmcZVPnNqOU3esaz7X8epjEsZR1xy-aa.png

#image 2
oYkY32ggtu64LNzJWZd7V3oLh6fbt910VPvntxjpKPbWibq8mBNjUIv1LJMFJBYp-1111.png

crossposted at:

http://www.mrexcel.com/forum/excel-q...ml#post4663865
http://ccm.net/forum/affich-933210-c...fier-in-excell
http://stackoverflow.com/questions/4...fier-in-excell
http://www.ozgrid.com/forum/showthre...817#post779817

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.

(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)

• Click Advanced next to Quick Post button at the bottom right of the editor box.
• Scroll down until you see "Manage Attachments",
• Click the "Choose" button at the upper left (upload from your computer).
• Select your file, click "open", click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Close the Attachment Manager window.
• Click "Submit Reply"

Note: Please do not attach password protected workbooks/worksheets
Ensure to disable any Workbook Open/Autorun macros before attaching!

crossposted: http://www.ozgrid.com/forum/showthre...d=1#post779819

http://www.mrexcel.com/forum/excel-q...ml#post4663865

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

sorry for that, cross post links added.

Thank you for complying with the moderators request to list cross posts. I assume that since you have not posted a solution, as you stated you would when you got one, that none have been proposed.
This solution uses two formulas. The following array entered formula* retrieves the DESC:

Formula:

Please Login or Register  to view this content.

The following formula will retrieve the numeric values:

Formula:

Please Login or Register  to view this content.

*Array entered formulae are activated by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
To see the formulae applied look at the 'for 312' sheet, yellow shaded section.
Let me know if you have any questions.