Welcome to the forum.
I dit it for the first budgeted item, this array formula in cell H4, copied down:
In this formula, the argument LEFT($I$2,SEARCH(" ",$I$2)-1) finds the string before the first space in the code entered in cell I2.
So the formula will search for that string in column E.
Careful with code spelling typos, in this case, the first section of codes (numbers up to first space) between register and budgets.
For example, cell E8 (6300-2), as compared to N10 (6300.2). Make sure the first section of codes match, so the formula will work.
I also improved your formula in cell K4, so you can copy down:
Please check file, run some test and let us know how it goes.
Good luck!
Bookmarks