How to Use the NEW & IMPROVED Excel XLOOKUP (with 5 Examples)

❤❤❤❤❤🎉🎉🎉

when i xlookup the percentage =XLOOKUP(A3,B_Master!$C$4:$C$28,B_Master!$B$4:$B$28) , its returning 0. can you please assist me on this.

probably the best tutorial

Super ❤❤❤❤❤

Terima kasih.

What about two criteria in separate columns? i.e. a SUMIFS but I just want to return the text in the cell?

You are amazing Leila. the way you explain and the examples you use are very useful. Thank you.

Great information but...

I have a different issue.

I want to look-up a value on a separate sheet, so price!

No problem

However, I have 2 columns.

EFT and Cash

Different return array,

Individually I can make this happen.

The problem I'm trying to simplify is as follows.

If a value is entered in the EFT column then Cash might be 0 or a split payment value. Assuming split is a rare option, I want to say

If EFT is empty then cash should look-up price! Cash column, if EFT is filled then cash should be considered null.

The total value is split

So if payment is cash $190, house keeps $60, worker gets $130. If payment is EFT then total is $205 so house keeps $75 and worker gets the same $130 as before.

Therefore many fields rely on other values.

At the moment I have cash setup to look-up time then return value, then worker looks-up and returns a value and house is one subtracted from the other

eg cash 190 - worker 130 so house = 60

If you are now confused then I guess you understand why I am also 😅

How do I return words within a date range?
For example, I want to return the name of the vehicle I used on this date but I had multiple vehicles throughout the year:
The data is in a table:

A is the start date
B is the end date
C is the name I want to return

😅😅😅

thank you

very helpful

i tried it but formula is not working i dont know the reason

Terima kasih.

That nested xlookup is lit🔥...thanks!!

Useless

New follower to your channel and am amazed I can actually understand AND implement the formulas you teach. Thank you A LOT!

Thanks

English nhi bolo

Good job

Indeed powerful I will be using te tutorials to enhance my skills

Great explanation and very smooth transition between examples. Thank you for this - really helpful.

Thanks

Hi, I have tried on multiple computers and F4 key doesn't work. I tried Ctrl + F4, just F4 key, shift + F4 key ,and FN + F4 key to lock my table array. What is the secret on how to use f4 key? I spent over 1 hr 1 day and still can't get it to work. Thanks

واقعا عالی بود. ممنون

Error Display window "There's a problem with this formula"
There's a problem with this formula.
Not trying to type a formula?
When the first character is an equal(=) or minus (-) sign, Excel thinks it's a formula.
you type: =1=1, cell shows : 2
To get around this, type an apostrophe (') firts:
you type: '=1=1, cell shows: =1+1

The answer:
Example on the TEXT formula they use a comma separator ( , ) on the examples and after spending ours of research i realize that it has to use the symbol ; that is used on the Spanish/Greek or maybe other EXCEL even do my EXCEL is on English.

Thank you very much @LeilaGharani , your videos really help a lot. in Xlookup am trying to return value which the return array is a dropdown list and i need four criteria for the list, i tried (nested Xlookup,IF,IFS and IF&OR) function but i cant find what i need

thank you

So I’m having an issue with how the data is returned. I need the data I’m pulling to be returned into one column but it keeps returning it into the row I enter the formula in. Whenever I hit the sort data options, it won’t execute the action to sort the data into the column I want… I know there’s a way to do what I want, can anyone help explain in layman’s terms…

Thank you :)

Why the first few numbers were slightly different when you used Xlookup horizontally? It seems like no one else in the comments noticed this.

What if it's hyperlink? What would the formula be?

I will be using XLookUp for my future files

nice! thank you , it is really helpful

Like a woman actually uses Excel and if she does use it, very limited.

Good explain madam looking super

Thank you

We just trust vlookup. No xlookup no Cry

How to ignore xlookup match blank cells in array and return value from another row?

Discriminating bonus

Leila, if the second value to lookup is a range of date, then xlookup is possible with Filter date? Can u post a video on that?

Terima kasih.

if a comma is not working use a semi colon

Thank you!!!!

Am I able to find a job bookkeeping without a degree?

which condition we can you use xlook up

Terima kasih.

hi Leila help me

Hi! Thank you for all your videos. They are very helpful! I created a table to import my credit card statements. However, I am having some issues. What do you do when the categories differ by a number or code from one month to another? Example: "AMAZON MKTPL*RC3EB61I1" and "AMAZON MKTPL*RC4GH9MM0
" They are both amazon purchases but every month I need to update the lookup table, because of the ID number for that transaction . Is there a way for Excel to recognize 1 or 2 words from a cell and tie them to one of my preset categories? Example: "AMAZON MKTPL". Thank you!!