Pull value from a cell that corresponds to checked box on different column [G.Sheets]

Hi all, i've scoured the internet and have had no luck. I am hoping you guys can help. I am doing this in Google Sheet so hopefully some of you may know. I am trying to display the data/value from a cell that corresponds to a checked box from a different column and display into a new cell. I've tried indexing and filter and I've tried a sumif to go through the checkedbox if true but no luck. I'll attach an image so it's easier to understand. So the formula needs to scan the E column, for example say in row 1. So E1:E to scan through entire column for check (true value) and the latest checked box, the K1:K column balance should display in cell where the formula will sit. In this sample, it should display the value 50.75.

According to your image, the last checked value already does show 50.75.

If this is not correct, then please provide a clear detailed explanation of why it is not correct, and what the results should look like. Also please provide provide a sample file, or a link to a google sheet file (modify the link so that this forum will accept the link)

heres link to a file that you can build your sample in.

please ensure that the sample data is in the exact same range as your original file.

https://docs.google.com/spreadsheets...gid=2100307022

once you have built the sample, let us know and then we can take another look at your enquiry.

Administrative Note:

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

(Note: this requirement is not optional. As a courtesy, I shall do it for you this time: https://www.mrexcel.com/board/thread...olumn.1221716/

Apps Scripts and formulas do very specific things based on very specific cell references and ranges.... if you are unable to help us to help you by providing some anonymous sample data in the exact layout of your real file, then you can learn to write apps scripts and formulas yourself.