Excell has won this round

Question

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.

bradd · Answer

Byn138&nbsp;yeah, that'll never work.&nbsp; 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.&nbsp; 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.

byn138 · Answer

BradD&nbsp;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.

sergeibaklan · Answer

Byn138&nbsp;
I'd transform dictionary table as

with it formula for Luggage Cost will be
=LOOKUP(E4,$G$117:$G$120,$H$117:$H$120)
&nbsp;

Forum Discussion

Excell has won this round

3 Replies

Resources