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.
I'd transform dictionary table as
with it formula for Luggage Cost will be
=LOOKUP(E4,$G$117:$G$120,$H$117:$H$120)