Hi, below is my formula I have that is working for a spreadsheet. It is pulling data based on a match from a different worksheet and sending back the correct data.
Example, if I drop in a budget into excel on one sheet, then on another sheet put in a drop down bar that changes the month of the year it automatically pulls in my detail budget from the referenced month.
My problem is that in two separate categories I have the same description, but different GL.
<tbody>
</tbody>
My problem is that my formula is referencing the name to match and not to GL, but when I change it to match the GL it doesn't work.
=IFERROR(INDEX('Budget Drop'!$B$4:$AZ$499,MATCH(B81,'Budget Drop'!$B$4:$B$499,0),MATCH($A$2,'Budget Drop'!$B$3:$AZ$3,0)),0)
So, because I have two separate GL's with the same name, it won't automatically drop in the budget amount because it doesn't know which one to pull.
I hope this makes sense and I hope you can help!
Example, if I drop in a budget into excel on one sheet, then on another sheet put in a drop down bar that changes the month of the year it automatically pulls in my detail budget from the referenced month.
My problem is that in two separate categories I have the same description, but different GL.
GL | Description | Actual | Budget |
50460 | Locks & Keys | 50 | 500 |
50350 | Locks & Keys | 50 | 300 |
<tbody>
</tbody>
My problem is that my formula is referencing the name to match and not to GL, but when I change it to match the GL it doesn't work.
=IFERROR(INDEX('Budget Drop'!$B$4:$AZ$499,MATCH(B81,'Budget Drop'!$B$4:$B$499,0),MATCH($A$2,'Budget Drop'!$B$3:$AZ$3,0)),0)
So, because I have two separate GL's with the same name, it won't automatically drop in the budget amount because it doesn't know which one to pull.
I hope this makes sense and I hope you can help!