Forum Discussion
Excell has won this round
I am so sorry to start off like this, but for some reason, my vlookup formula in J4 won't recognise the value in E4.
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.
