VLOOKUP vs XLOOKUP with Multiple Cell Criteria
Vložit
- čas přidán 8. 09. 2020
- Download the featured file here www.bluepecantraining.com/per...
This video looks at three ways to perform a lookup using multiple cell criteria. The methods are:
XLOOKUP (Office 365 or Excel Online)
VLOOKUP with helper column in lookup table
VLOOKUP with CHOOSE array formula.
------------------------ - Jak na to + styl
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 much for explaining multiple cell criteria xlookup in 2,5 minutes!!! Superb!
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 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 very much really easy to follow tutorial and just saved me a ton of manual work ❤️
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!
Hey, you saved my afternoon free time. Thank you! Im Very happy now!
Ampersand to the rescue once again, didn’t know you could just do that. Thank you!
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!
Thank you! Works great on excel data formatted as tables.
After watching too many videos, only you were able to solve my problem...Like and Subscribed...Thank u
Legend! Thanks for the easy explanation
Im getting #VALUE error. Pls give me solution
Thanks for this information 👍 , because as an accountant is very important !
Thank you so much for this video !
I love xlookup
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.
I was banging my head since long for this...thank you so much for this video. It saved my 2 hrs time..
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)
I wanted to say Thankyou!!! Really helpful!!
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.
Thanks a lot for this formula. It helped me a lot 😊
Great job!
No words Can make you know how i thank you💛 You saved me
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 for clear and simple explanation ...
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
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
Thanks so much. Quite helpful and I like your English!
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
does it work if the table are in different pages and not at each other side?
Thank you, it's very useful.
You absolute legend.
Great information!
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
That's great!!!!!!!! Thank you so much.....
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.
What if lookup value in 2 cell and lookup array in 4 columns, how do will apply formula ?
Excellent Thanks
Does the first example with 2 criteria work as-is in Google sheets? I cannot replicate it for some reason
Great really helpful
És o rei mano
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.
Thanx
And here I was thinking of myself being so savy for knowing VLOOKUP, then XLOOKUP came along.
Sumsifs…?
U sold a very big problem for me
Nice job..once please given the excel file
See description.
Works perfectly on PC but not working on Google sheets