Hi
can anyone help me with this formula please.
its just not doing what i want it to do.=VLOOKUP(D9,Agency_Contract!C9:Y11,22,IF(J9>Agency_Contract!X9,J9-Agency_Contract!X9,0))
vlookup references based on a D9
IF is what i want it to do
ive even tried it like this but this one just returns the value in J9 but i dont want that to happen
=IF(J10>Agency_Contract!X10,J10-Agency_Contract!X10,VLOOKUP(D10,Agency_Contract!C10:Y12,22))