Excel - Please HELP

New Contributor

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. 


I have a general Table where I fill all of the information into. 

I need to create a formula to take the new input [A1 (XXPO_230) B1(Cost: €20)] from budget [G1 (XXPO_230) H2(Value: $30000) and put into C1(The remainder of the PO per each step if (XXPO_230) is used.


If XXPO_123456 with a budget of 20000 is used it will display that value on each step


So say I use budget code  'XXPO_230' for the amount of $1,000 C1; will display €29,000

followed by using the code 'XXPO_230' for the amount of $2,000 C2; will display €27,000

followed down the line by ' XXPO_123456' for the amount of $5,000; C3; should display $15,000


I've attached an excel of what I would like.. If anyone has any advice on this it would be much appreciated! 

6 Replies

Hi Shaun,


There is no file attached.

Hi Sergei, 


Hopefully it is attaching to this response. 


Kind regards,


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



Hi Sergei,

That's exactly what I wanted. Thank you very much!

Kind regards,
Hi Sergei,

That's exactly what I wanted! Thank you very much

Hi Shaun,


So far so good, glad to help

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies