Hi Everyone,
Can someone let me know what I'm doing wrong here. I'm trying to do an index match function and I'm returning an error. Here is my formula:
=INDEX('Overhead Budgets'!$E$4:$E$197,MATCH($C$5&$C$6,'Overhead Budgets'!$C$4:$C$197&'Overhead Budgets'!$D$4:$D$197,0))
The two criteria I'm looking at are in cells C5 and C6. The data to match this too is in the Overhead Budgets sheet. For cell C5, the data to match it to is in C3:C197. In cell C6, the data to match is in D4:D197. The return result (the budget) i want to return is in column E.
Any idea where I'm going wrong with my formula?
Bookmarks