I hope you can help. I am trying to find one cell in a column and then find another cell in the same column and then sum what is between the cells of the column. I tried the formula below however it did not work and I was hoping you could help.
=SUM(VLOOKUP(Form!H3,’Deal Scenario 1 ‘!E3:Y219,4,TRUE):VLOOKUP(Form!I3,’Deal Scenario 1 ‘!E3:Y219,4,TRUE))
Please let me know.