Modify this idea to suit from my test below
=INDEX(Sheet15!14:14,0,MATCH($B$13,Sheet15!$D$12:$ P$12)*2+5)
change to your sheet name
=INDEX(Sheet15!41:41,0,MATCH(a4,Sheet15!$D$12:$P$1 2)*2+5)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"jcheko" wrote in message
...
I know it looks kind of bad but it is an IF function (7 of them) that reads
the value of a column in a worksheet that has 7 columns and puts it in a
specific cell in another work sheet, not a big deal, but it has worked for
me, but if two columns have the same cost code it will only bring in the
info
from the first column that has that same cost code, 2 are my questions
first:
can I make it any shorter? and is there a way of summing up the info of
all
the columns that have the same cost code it could be in two, three up two
7
columns?

=IF(A4='Foreman''s DTC(1)'!$D$12,'Foreman''s
DTC(1)'!$E$41,IF(A4='Foreman''s
DTC(1)'!$F$12,'Foreman''s DTC(1)'!$G$41,IF(A4='Foreman''s
DTC(1)'!$H$12,'Foreman''s DTC(1)'!$I$41,IF(A4='Foreman''s
DTC(1)'!$J$12,'Foreman''s DTC(1)'!$K$41,IF(A4='Foreman''s
DTC(1)'!$L$12,'Foreman''s DTC(1)'!$M$41,IF(A4='Foreman''s
DTC(1)'!$N$12,'Foreman''s DTC(1)'!$O$41,IF(A4='Foreman''s
DTC(1)'!$P$12,'Foreman''s DTC(1)'!$Q$41,"0")))))))

Thanks,