I am using the same example as in your video. I keep betting the #NAME for my solution. This is the formula I am using: =xlookup(J5,A2:A4,xlookup(J6,B1:F1,B2:F4)) Where J5 = Jacket, A2:A4 contains Jacket, J6 = S, B1:F1 contains S, and the price is in the B2:F4 section. I looked and it says I am using Microsoft Home and Office 2019.
Yeah, that's the problem. XLOOKUP is only available to Microsoft 365 subscribers. Initially it was announced that it would be included in Office 2019, but Microsoft changed it to 365 only. That's why you're getting the error. Your Excel has no idea what XLOOKUP is.
Tim SchmidtOP
@Reply 5 years ago
I want to say that you havr helped me in a lot of questions, bur could you tell me how I get Office 365. I purchased yearly for $75.00 but can not see how to get it. Any assistance would be greatly appreciated.
Tim
Scott Axton
@Reply 5 years ago
Tim -
You should have received an email when you signed up. That will have the links.
Here is a link to get Office 365 installed -
https://support.microsoft.com/en-us/office/download-and-install-or-reinstall-microsoft-365-or-office-2019-on-a-pc-or-mac-4414eaaf-0478-48be-9c42-23adc4716658?ui=en-us&rs=en-us&ad=us
If you still have issues try and provide step by step what you're doing and specific as you can.
Hope this helps!
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Excel Expert 11.
