enter a value when multiple criteria match

[RCBricker]

Hello all,

I have a spreadsheet that has about 86000 lines in any given month. I am trying to lock down clearing entires. I have to match two different system names & exact values & D# value (its like an entry number when the transaction is originally generated) to clear them.

Due to the number of variable I would like to stay with formulas rather than VBA as I will have to change the formula when needed.

I have 86000 lines of data
I have about 13 different system names
I have various dollar amounts
too many D# to count

So I am trying to MHS to CHOs (system names) & $5000 to $5000 & 63350 to 63350. IF there is a Line with MHS for $5000 with a D# of 63350 AND if there is a line with CHOs for $5000 with a D# of 63350 Then I need to have both instances return a value in column D that matches but is sequential to other matches.

The hard part is the system name as they will not match but be another system name (pairings differ so I will have to make changes to the formula as I go)

SYSTEM NAME is in Column A
Value is in Column B
D# is in Column C

I am sure this can be done and I have been playing with index / match but I am not sure how to tell excel to look for the alternating system names.

Thanks all

Rich