Brilliant video and so easily explained. Thank you so much. This has saved me at least 15 minutes everyday trying to find values with multiple criteria.
Thank you so for much for making this video. I'd been looking everywhere for an explanation on how to do this. This video has solved my issue perfectly. Thanks again!
Thank you so much for this well put together video. I looked through 5 videos before finding your video. It was straight, to the point and just what I needed. THANK YOU!
Thank you for your help. I had done the formula and I kept getting the wrong answer. Still, I watched your video and learned I had to use Ctrl+Shift+Enter for older Excel versions. Thanks.
Excellent, thank you very much. Could you please provide the same example but with multiple columns to lookup in the table array (I.E., say there were additional budget columns from a different fiscal years)
Hi Chester, love your channel! I am trying to use a VLOOKUP to pull a specific piece of data matched up below a column header and along side a row header. Do you have a video for this? I am really struggling!
Hey...this multi criteria isn't working with Ms office 2021 in my system.. However its working absolutely fine on Excel web.. any idea what's wrong? I downloaded new excel functions as well and added in add ins, still getting and#NA error
In the first step of the Xlookup function, is it possible to do a wildcard search on one of the cells? For example, it would start off like =xlookup("*"&$F4&"*"&G$3, ...? I am trying to output the result of multiple search criteria in my sheet, and it works when one of the criteria is an exact match to the reference, but I don't want to have to rename everything that is slightly off.
For some reason I am getting a Value error and I am breaking my head whole day but couldn't figure it out. The lookup array is a different dimension and return array is a different dimension.
I tried using ">0" as one of my criteria items but that didn't seem to work. Any solution where you want to specify a range rather than a specific value? Cheers
Hi. If 1 of my criterias are numbers(column F in your video), but I want the formula to still work if the number in the Data table is "within" 5 digits of the F cell criteria, then how would I change the formula? Example: if F4 = 100 and A2 = 96, then G4 = £1,247.(training would be the 2nd criteria of course) Thank you P.S. I have 365
Brilliant video and so easily explained. Thank you so much. This has saved me at least 15 minutes everyday trying to find values with multiple criteria.
I was burning my neurons to do an xlookup with two criteria and was a matter of having the "&" connecting the two criteria, thank you so much.
Thank You so much for explaining multiple cell criteria xlookup in 2,5 minutes!!! Superb!
Thank you so for much for making this video. I'd been looking everywhere for an explanation on how to do this. This video has solved my issue perfectly. Thanks again!
Great video, why have I never heard of XLookup before, what a great function
Thank you so much for this well put together video. I looked through 5 videos before finding your video. It was straight, to the point and just what I needed. THANK YOU!
After watching too many videos, only you were able to solve my problem...Like and Subscribed...Thank u
Many many thanks you have just solve my prob within seconds......Really very helpful video
Thank you so much I was struggling with VLOOKUP the whole day and in 10 minutes I was able to do what I needed through XLOOKUP
I was banging my head since long for this...thank you so much for this video. It saved my 2 hrs time..
Ampersand to the rescue once again, didn’t know you could just do that. Thank you!
Hey, you saved my afternoon free time. Thank you! Im Very happy now!
Thank you so much! I was trying to find a value in a table with multiple values. At first, I was using "Countif," but this was much better.
No words Can make you know how i thank you💛 You saved me
Thanks a lot for this formula. It helped me a lot 😊
Thank you for your help. I had done the formula and I kept getting the wrong answer.
Still, I watched your video and learned I had to use Ctrl+Shift+Enter for older Excel versions. Thanks.
Thank you very much really easy to follow tutorial and just saved me a ton of manual work ❤️
Thank you very much for clear and simple explanation ...
Thank you! Works great on excel data formatted as tables.
Thank you so much for this video !
I love xlookup
Thanks so much. Quite helpful and I like your English!
Excellent, thank you very much. Could you please provide the same example but with multiple columns to lookup in the table array (I.E., say there were additional budget columns from a different fiscal years)
Thanks for this information 👍 , because as an accountant is very important !
I wanted to say Thankyou!!! Really helpful!!
Thank you, it's very useful.
Great information!
Legend! Thanks for the easy explanation
Hi Chester, love your channel! I am trying to use a VLOOKUP to pull a specific piece of data matched up below a column header and along side a row header. Do you have a video for this? I am really struggling!
Hey...this multi criteria isn't working with Ms office 2021 in my system.. However its working absolutely fine on Excel web.. any idea what's wrong? I downloaded new excel functions as well and added in add ins, still getting and#NA error
Great job!
In the first step of the Xlookup function, is it possible to do a wildcard search on one of the cells? For example, it would start off like =xlookup("*"&$F4&"*"&G$3, ...? I am trying to output the result of multiple search criteria in my sheet, and it works when one of the criteria is an exact match to the reference, but I don't want to have to rename everything that is slightly off.
Im getting #VALUE error. Pls give me solution
Does the first example with 2 criteria work as-is in Google sheets? I cannot replicate it for some reason
You absolute legend.
That's great!!!!!!!! Thank you so much.....
For some reason I am getting a Value error and I am breaking my head whole day but couldn't figure it out. The lookup array is a different dimension and return array is a different dimension.
does it work if the table are in different pages and not at each other side?
What if lookup value in 2 cell and lookup array in 4 columns, how do will apply formula ?
Great really helpful
My file gets really slow after entering that formula, it keeps calculating every time I change cells, and I need the automatic calculation to be on.
I tried using ">0" as one of my criteria items but that didn't seem to work. Any solution where you want to specify a range rather than a specific value? Cheers
Hi.
If 1 of my criterias are numbers(column F in your video), but I want the formula to still work if the number in the Data table is "within" 5 digits of the F cell criteria, then how would I change the formula?
Example: if F4 = 100 and A2 = 96, then G4 = £1,247.(training would be the 2nd criteria of course)
Thank you
P.S. I have 365
Excellent Thanks
And here I was thinking of myself being so savy for knowing VLOOKUP, then XLOOKUP came along.
És o rei mano
Nice job..once please given the excel file
See description.
Works perfectly on PC but not working on Google sheets
Thanx
Sumsifs…?
U sold a very big problem for me