return data in multiple columns using "if"?

J

JENNYC

Hello!
I am looking for a formula that will return the data in columns "G"
through "L" if certain criteria are met in column "c". is there a
simple way to do this with one formula?
 
S

swatsp0p

The short answer to your question is "maybe". It really depends a lo
on just what your criteria is for returning a value. Is it always i
the same row? Are we looking at values or text?

More info, please. Give some real life data examples.

Thank you
 
V

vezerid

Depends on what you want to put in these columns. If all the cells have
the same calculation, you can do it by selecting the entire range that
you want and then use:
=IF($C2=..., calculation). When finished editing use Ctrl+Enter.

HTH
Kostis Vezerides
 
J

JENNYC

ok, sorry!!

in column C i will have have initials of 1 of 3 different managers.
in columns G - L there will be different dollar amounts (for differen
options sold). In this main workbook there are 16 different sheets fo
different depts.

i need to link another workbook to this main workbook that will retur
the amounts in columns G through L each time it sees a certain set o
initials in column C. Is that a little more clear foor you?? :
 
Top