I have an HLOOKUP formula which is working fine but there are a few instances where there are two consecutive records where I have an exact match and would like the formula to retrieve the sum of the two amounts. Currently, the formula only returns the first value. Any suggestions?