2 columns

D

darkbearpooh1

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?
 
P

Pete_UK

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

Pete
 
D

darkbearpooh1

=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
 
Top