Dec 31 2020
11:04 PM
- last edited on
Feb 01 2023
11:46 AM
by
TechCommunityAP
Dec 31 2020
11:04 PM
- last edited on
Feb 01 2023
11:46 AM
by
TechCommunityAP
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.
Jan 01 2021 02:43 AM
@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.
Jan 01 2021 10:28 PM
@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.
Jan 03 2021 03:40 AM
I'd transform dictionary table as
with it formula for Luggage Cost will be
=LOOKUP(E4,$G$117:$G$120,$H$117:$H$120)