Dec 31 2020 11:04 PM
Jan 01 2021 02:43 AM
@Byn138 yeah, that'll never work. It's not that simple and you'll never get a result using VLOOKUP like that.
I changed it which is more complex and there's probably a better way but it works. It's using an array formula which you should probably read up on if you want to go with this approach.
I also changed the format of your fees table so it's using scales rather than ranges.