Hi Guys—

I have been toiling on this all day and cannot seem to marry these two formulas into one.

Here's the setup:

Lookup section:
Column B - Job-specific region
Column F - Job-specific activity code
Column H - Job-specific unique identifiers

Database section:
Column AZ - long strings of text containing unique identifiers (addresses, project numbers, etc.) [Ex: "13428619 1DKD7801-413 AC 935 W11TH ST"]
Column BC - regions
Column BA - activity codes
Column BE - dollar amounts (from which the final sumifs will tally)

In column S (let's say cell S72) are the cells where I need the formula to return a vlookup/index-match of B72 in BC, F72 in BA and then search AZ for text containing the text in H72 (935 W11TH ST for this example).

This formula works correctly:=SUMIFS(BE77:BE81,BC77:BC81,B79,BA77:BA81,F79)

It's when I introduce the unique identifier text string search. (cell H72: "935 W11TH ST" within "13428619 1DKD7801-413 AC 935 W11TH ST")

This formula for some reason returns "FALSE" even though the H72 text exists several times in column AZ:=IF(ISNUMBER(SEARCH("H72",AZ77:AZ81)),"")
it does not work with or without "quotes" around H72

I just really need the complete formula which searches for all 3 criteria.

Thanks in advance. I hope someone may be able to help.
J