Adonaioc
03-28-2008, 11:40 AM
Hey, I need some help,
I have a master sheet that gets entered by hand, and then i have sheets that pull items from the master if the value in column g is the right number
=IF(INDIRECT("Master!$G3")=3,INDIRECT("Master!D3"),"")
so sheet m3 pulls all rows from the master that have a 3 in column g
I need it to also pull the fill color from that cell as well. preferably by static address the same as the formula. the master is constantly having rows inserted and deleted that is why i need the address to be static so my reference sheets are not always getting messed up. anyone help?
I have a master sheet that gets entered by hand, and then i have sheets that pull items from the master if the value in column g is the right number
=IF(INDIRECT("Master!$G3")=3,INDIRECT("Master!D3"),"")
so sheet m3 pulls all rows from the master that have a 3 in column g
I need it to also pull the fill color from that cell as well. preferably by static address the same as the formula. the master is constantly having rows inserted and deleted that is why i need the address to be static so my reference sheets are not always getting messed up. anyone help?