Hi,

I have the following data:

Jan YTD Feb YTD Mar YTD
Acct#1 5 10 15
Acct#2 3 6 9
Acct#3 4 8 12


On a separate March analysis tab, using an
=Index(Range,Match(...),Match(...)) formula, I have pulled in the balance of
Acct #2 for Mar YTD. Now I would like to calculate the Mar MTD amount by
subtracting the Feb YTD balance. Do I have to do a second =Index formula to
pull the Feb YTD balance, or is there a function or formula that would simply
pick up and subtract the amount in the cell to the left my Acct#2, Mar YTD
Index result?

Thanks