Hi, I'm trying to return the correct delivery method from the table into cell F7. I've tried XLOOKUP and Index, Match but can't get the formulas to work. Any help would be much appreciated. Thanks.
Formula:
Please Login or Register to view this content.
Formula:Please Login or Register to view this content.
How aboutFormula:Please Login or Register to view this content.
Perfect!!! I spent ages this morning trying to get that to work.....
Thanks again.
You're welcome & thanks for the feedback.
You are using XLOOKUP, so this formula should also work:Formula:Please Login or Register to view this content.
A very neat solution! Thank you.
You are Welcome!
Thanks for the feedback and rep
Glad to have helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks