How to use Excel Index Match (the right way)

Suppose if in place of Revenue if the Hiredate is written & below cells value in date format than will it work same as there is switching between two format. I did it and unable to fix the issue

Thank You

where is your next lecture sister!!

Thanks!

Amazing 😻 thanks!

Very well explained👍🏻

Thank you so much for the way you explained it, I've watched it yesterday and today I was following your instruction based on the way you were describing like where the map and what I want exactly her
you made it too easy Thanks

Leila entiendo ingles y lo hablo pero si hicieras videos en espanol tus seguidores se triplicarian ❤

I have absolutely no idea what she is talking about 🙃

Hello Bill. I have an excel file that has two sheets. Sheet 1 is the balance from sheet two. Sheet two data is a tracker of all raw materials for all the days for a period (let’s say January) with their beginning and ending balance . I will like to duplicate this two sheets for the month of February. I want the ending balance in January sheet two to automatically pop up in the February sheet two as the beginning balance. So that whenever January sheet 2 update , it automatically update also in February without having to do it manually. Can I use this function or what will you recommend

Thank you so much, nobody could explain it better!

Leila is a true love an adorable personality. She never demanded that if you need any technical help despite my uploaded lectures now pay me consultancy charges like every Tom, Dick and Harry like others in Pakistan are doing just to mint money after they deliver the worst quality lectures

why did this sound so complicated and hard??

futile video, with bad example..

excellent!

How to count how many cells are used in a merged cell in google sheets

Thanks so much, your video have been really helpful..

how to identify array, criteria, value , false, and true in excel, that's my problem in Excel

That was actually quite helpful and well explained! Thanks. By the way: would be cool if you would also make videos in German/Austrian! Best regards from Germany

@ leila gharani. I wish for you good health and better future.

I need some help! The formula works fine but for some reason if I drag it down it just gives back the first result. It is not because I didnt use dollar signs. If I double click in the formula and enter then it fixes itself. But that means you have to do it for each cell. Is it just too much data???

As usual , one of the best!

hi. i'm trying to match the quantities in 2 different excel files that have the same information but sorted differently. I want to know what are the numbers that the quantities have been changed, i thought i could use Index & match, but i can't following this video. (i'm not an expert in excel) but do you have another way to do that? thank you

unable to download workbook

Hi Leila,

Thanks for your video, very informative and clear as always.

I'm creating my own personal budget planning excel and I have a question.. how would you go ahead and use INDEX & MATCH in following scenario:

One Table with columns @Date, @Type (e.g. income, expenses, savings), @Category (like salary, housing etc), @Amount, @EffectiveDate

Now when you create a feature which allows the late month salary (e.g. 29-Mar-23) to be transfered to next month (because in reality you spend the late month salary in the next month), the value in @EffectiveDate column is 1-Apr-23. The transfer is easy if you only need to transfer the salary to next month, by just approximiting the payday, below is function for every salary-category after 25th of each month.

=IF(AND([@Category]="salary",DAY([@Date])>=25)),
DATE(YEAR([@Date]),MONTH([@Date])+1,1),
[@Date])

But how would you transfer all the remaining rows (expenses, savings) after salary row to the next month? When the salary is paid between 26th-31st (depending on month and weekends), a lot of that salary is already spent during end of the month (next month's loans, insurances etc). So their effective date should be next month as well. E.g fictious rows below.

@Date, @Type, @Category, @Amount, @EffectiveDate
#01: 24-Mar-23, Expenses, Groceries, 50€, 24-Mar-23
#02: 27-Mar-23, Expenses, Entertainment, 25€, 25-Mar-23
#03: 29-Mar-23, Expenses, Groceries, 15€, 25-Mar-23
#04: 30-Mar-23, Income, Salary, 4500€, 01-Apr-23
#05: 30-Mar-23, Expenses, Mortgage, 600€, 01-Apr-23
#06: 30-Mar-23, Expenses, Insurances, 200€, 01-Apr-23
#07: 30-Mar-23, Expenses, Credit Card, 100€, 01-Apr-23
#08: 30-Mar-23, Savings, Emergency fund, 50€, 01-Apr-23
#09: 01-Apr-23, Expenses, Haircut, 30€, 01-Apr-23
#10: 02-Apr-23, Expenses, Groceries, 50€, 02-Apr-23

With INDEX MATCH I have managed to get only the first salary row as number and it's @Date value. How would rows 5-8 know the @EffectiveDate of salary on row 4 has been changed and theirs need to be changed as well? Estimated date no longer works here, because I don't want to transfer rows before salary (rows 2 & 3). I thought to make a year/month view so there would be only one salary row in a view, which would perhaps made it easier. But can it be done if there are rows for the whole year, so 12 salary rows? Each row should be aware of the month and year they are on (thanks to @Date column) but how they also know the last salary row of that month and year?

I just can't get my head around it, any tips appreciated.

Who ever invented Excel needs a noble prize!

wonderful!

The last part is insane! amazing!

I had known this years ago but have come back to this video again to remember. Great example here.

super helpful!!!

what if there is a numeric value is in text format, in that case what should i do.

Wow, this is awesome! I do work with very large datasets sometimes and had faced the LOOKUP issues you've mentioned.
Thank you so much!!!

THank ypu! Yo've made it very simple to follow and therefore easy to learn

You are a savior....... thank you so much for this guidance. I was stuck for so long in many problems regarding index match and vlookup, thanks teacher.

Woo, I love your explanation! So clear and easy to understand :)

Leila, you are great lecturer good in communication techniques and clear in step by step illustration.

I could not find a better video on this topic. Thank you so much and keeping posting such a wonderful videos ..

THANKS

super helpful !

She is actually amazingly gorgeous.

Thanks tất cả các bạn Tôi đi ngủ một chút a chúc các bạn ngủ ngon a

I doesn't work, it simply doesn't, value# and n/a# error all the way

Hi Leila,

One quick question, why do we need to select headers to match Profit and Revenue?

I think xlookup made it alot easier Now

what if the columns doesn't sync

CAME BACK TO SAY I PASSED!!! LEILA UR THE PRETTIEST!!

Amazing thank you

Clear enough to understand and apply Index and Match, Nice explanation and worksheet sample.