Forum Discussion
Solved
Excel - Please HELP
Im trying to do this for work. Im Trying to create a formula that produces a budget amount from a table with a budget code with a corresponding Budget amount. I've used a Vlookup for this. ...
Hi Shaun,
So far so good, glad to help
Hi Shaun,
There is no file attached.
Hi Sergei,
Hopefully it is attaching to this response.
Kind regards,
Shaun
Shaun, not sure I understood what is needed since samples in your post are fully different from what is in your sample file. However, for the latest to calculate Effective budget
=INDEX($P$4:$P$6,MATCH(A2,$O$4:$O$6,0))-SUMIF($A$2:$A2,$A2,$B$2:$B2)
- Hi Sergei,
That's exactly what I wanted! Thank you very much - Hi Sergei,
That's exactly what I wanted. Thank you very much!
Kind regards,
ShaunHi Shaun,
So far so good, glad to help