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

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

Pete

=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

See your other thread.

Biff

"darkbearpooh1" <(E-Mail Removed)>
wrote in message
news:(E-Mail Removed)...
>
> 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
>