VLOOKUP vs XLOOKUP with Multiple Cell Criteria
Тәжірибелік нұсқаулар және стиль
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.
------------------------
Пікірлер: 51
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!
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
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 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 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.
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 very much really easy to follow tutorial and just saved me a ton of manual work ❤️
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!
After watching too many videos, only you were able to solve my problem...Like and Subscribed...Thank u
I was banging my head since long for this...thank you so much for this video. It saved my 2 hrs time..
Thank you! Works great on excel data formatted as tables.
Great job!
I wanted to say Thankyou!!! Really helpful!!
Im getting #VALUE error. Pls give me solution
Thank you so much for this video ! I love xlookup
Great really helpful
Thanks for this information 👍 , because as an accountant is very important !
Thanks a lot for this formula. It helped me a lot 😊
No words Can make you know how i thank you💛 You saved me
Thank you very much for clear and simple explanation ...
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)
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
Thanks so much. Quite helpful and I like your English!
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
Thank you, it's very useful.
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.
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.
You absolute legend.
Does the first example with 2 criteria work as-is in Google sheets? I cannot replicate it for some reason
Great information!
does it work if the table are in different pages and not at each other side?
That's great!!!!!!!! Thank you so much.....
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
What if lookup value in 2 cell and lookup array in 4 columns, how do will apply formula ?
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.
Excellent Thanks
És o rei mano
And here I was thinking of myself being so savy for knowing VLOOKUP, then XLOOKUP came along.
Thanx
Works perfectly on PC but not working on Google sheets
Sumsifs…?
Nice job..once please given the excel file
@ChesterTugwell
3 жыл бұрын
See description.