Copying values in cell based on a number/identifier in excell [Closed]

Registration date
Saturday October 22, 2016
Last seen
October 22, 2016
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)

Thanks for any help :)

image #1

image #2

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!