Excell has won this round

%3CLINGO-SUB%20id%3D%22lingo-sub-2025103%22%20slang%3D%22en-US%22%3EExcell%20has%20won%20this%20round%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2025103%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20so%20sorry%20to%20start%20off%20like%20this%2C%20but%20for%20some%20reason%2C%20my%20vlookup%20formula%20in%20J4%20won't%20recognise%20the%20value%20in%20E4.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2025103%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EEducation%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%20Groups%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2025357%22%20slang%3D%22en-US%22%3ERe%3A%20Excell%20has%20won%20this%20round%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2025357%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F915306%22%20target%3D%22_blank%22%3E%40Byn138%3C%2FA%3E%26nbsp%3Byeah%2C%20that'll%20never%20work.%26nbsp%3B%20It's%20not%20that%20simple%20and%20you'll%20never%20get%20a%20result%20using%20VLOOKUP%20like%20that.%3C%2FP%3E%3CP%3EI%20changed%20it%20which%20is%20more%20complex%20and%20there's%20probably%20a%20better%20way%20but%20it%20works.%26nbsp%3B%20It's%20using%20an%20array%20formula%20which%20you%20should%20probably%20read%20up%20on%20if%20you%20want%20to%20go%20with%20this%20approach.%3C%2FP%3E%3CP%3EI%20also%20changed%20the%20format%20of%20your%20fees%20table%20so%20it's%20using%20scales%20rather%20than%20ranges.%3C%2FP%3E%3C%2FLINGO-BODY%3E
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.

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