It seems so easy but stumped!
Here is the formula:
=IFERROR(IF(F14="Basic", VLOOKUP(E14,'DAI Obligations'!$K$1:$AV$367,30, FALSE), 0),0)
If Cell F14 is "Basic", it picks up the Requisition Number in Cell E14 and finds a match in the DAI Obligation worksheet and brings back the number in column 30, which are the $$.
It's fine until there are multiple instances of the exact same Requisition Number, at which point it only picks up one of them then stops.
Looking for a way to SUM all of the instances, otherwise our data is no good. I have been thus far very unsuccessful.
I'd be super grateful for any help. Optimally I would just like to adjust the formula.
Here is the formula:
=IFERROR(IF(F14="Basic", VLOOKUP(E14,'DAI Obligations'!$K$1:$AV$367,30, FALSE), 0),0)
If Cell F14 is "Basic", it picks up the Requisition Number in Cell E14 and finds a match in the DAI Obligation worksheet and brings back the number in column 30, which are the $$.
It's fine until there are multiple instances of the exact same Requisition Number, at which point it only picks up one of them then stops.
Looking for a way to SUM all of the instances, otherwise our data is no good. I have been thus far very unsuccessful.
I'd be super grateful for any help. Optimally I would just like to adjust the formula.