Excell has won this round

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

@Byn138 

I'd transform dictionary table as

image.png

with it formula for Luggage Cost will be

=LOOKUP(E4,$G$117:$G$120,$H$117:$H$120)