Review this if function please.....

J

jcheko

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need this IF function to add if any value that it examines is the 1
Finding values in different rows/columns 1
Combine Two Similar Arrays 2
Return value based on certain criteria 3
How do I use sumif and mid function in same formula 2
Time and the Max Function 15
Chart For Hiring Plan 0
for each in a range 1

Top