software

How can I make my formula look in two columns as if it were one without
messing up the formula ? simply holding control to select the second
column data doesn't seem to be working is there a way to name the two
columns in advance or something then call it in the formula?--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile: www.excelforum.com/member.php...oamp;userid=30640
View this thread: www.excelforum.com/showthread...hreadid=514891What formula do you have (or are thinking of creating)? Are your two
columns adjacent?

Pete
=IF(ISNA(MATCH($A7,INDIRECT(B$5amp;quot;!H28:H46quot;),0)),quot;quot; ,SUMIF(INDIRECT(B$5amp;quot;!H28:H46quot;),$A7,INDIRECT(B$5amp;quot; !I28:I46quot;)))
this formula to lookup from another sheet but the H28:H46 needs to also
be combined to look in BC28:BC46 and find the answer in not only I28:I46
but also AY28:AY46--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile: www.excelforum.com/member.php...oamp;userid=30640
View this thread: www.excelforum.com/showthread...hreadid=514891See your other thread.

Biff

quot;darkbearpooh1quot; gt;
wrote in message
news:darkbearpooh1.23l3cy_1140533106.633@excelforu m-nospam.com...
gt;
gt; How can I make my formula look in two columns as if it were one without
gt; messing up the formula ? simply holding control to select the second
gt; column data doesn't seem to be working is there a way to name the two
gt; columns in advance or something then call it in the formula?
gt;
gt;
gt; --
gt; darkbearpooh1
gt; ------------------------------------------------------------------------
gt; darkbearpooh1's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30640
gt; View this thread: www.excelforum.com/showthread...hreadid=514891
gt;