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?


--
JENNYC
------------------------------------------------------------------------
JENNYC's Profile: http://www.excelforum.com/member.php...o&userid=19579
View this thread: http://www.excelforum.com/showthread...hreadid=482879

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

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

Thank you.


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=482879

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

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 different
options sold). In this main workbook there are 16 different sheets for
different depts.

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


--
JENNYC
------------------------------------------------------------------------
JENNYC's Profile: http://www.excelforum.com/member.php...o&userid=19579
View this thread: http://www.excelforum.com/showthread...hreadid=482879