2 columns
 

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: http://www.excelforum.com/member.php...o&userid=30640
View this thread: http://www.excelforum.com/showthread...hreadid=514891

2 columns
 

What formula do you have (or are thinking of creating)? Are your two
columns adjacent?

Pete

2 columns
 

=IF(ISNA(MATCH($A7,INDIRECT(B$5&"!H28:H46"),0)),"" ,SUMIF(INDIRECT(B$5&"!H28:H46"),$A7,INDIRECT(B$5&" !I28:I46")))
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: http://www.excelforum.com/member.php...o&userid=30640
View this thread: http://www.excelforum.com/showthread...hreadid=514891

2 columns
 

See your other thread.

Biff

"darkbearpooh1"
wrote in message
news:darkbearpooh1.23l3cy_1140533106.633@excelforu m-nospam.com...

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:
http://www.excelforum.com/member.php...o&userid=30640
View this thread: http://www.excelforum.com/showthread...hreadid=514891