Forum Discussion
Formula creation
I used XLOOKUP, which is only available in Excel in Microsoft 365 and Office 2021.
The version attached to this reply uses VLOOKUP.
Thank you so much! The formula for Question 1 works perfectly, as does the simplified formula for J2.
However, I can't seem to make either formula (I copied the formula out of your .xlsx file as well as trying the formula in your reply above) for Question 2, in the K2 cell, work, except to give me a 0 result if Delivery is RM. I worked out that the reference to G3 and F3 in the formula in your text above should be G2 and F2, but that still doesn't work. Using either formula with a Delivery method of APC, gives me a result of #NAME?
Sorry if I am missing something obvious?
Thank you also for pointing out there was a hidden sheet 🤦:female_sign: I realised the VLOOKUP formula must have been referencing something else, but had no idea what, or where, it was. Now that I know it is there, I can update it and look to use it 👍
I used XLOOKUP, which is only available in Excel in Microsoft 365 and Office 2021.
The version attached to this reply uses VLOOKUP.
HansVogelaar Amazing! Thank you so much, works perfectly now.
