Excell has won this round

New Contributor

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.

3 Replies

@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.

@BradD I can't thank you enough for your help!

I have been pulling my hair out trying to get it to work.

Thank you so much.

All the best.


I'd transform dictionary table as


with it formula for Luggage Cost will be