you are the best in explaining things in excel! please don’t ever get tired in sharing your knowledge 😭. I’ll be the one supporting you till the end

Thank you - Xlookup worked. For those who might have problems, make sure to check your look up arrays.

Wow, solved my problem in so many ways! Very clear and straight forward. Thanks for the video!

Good explanation, thanks Paul

🙏🙏🙏🙏thanks a lot.....that's a great value addition

Thank you 🙏

great vid thanks alot

Thank you :)

thanks paul

Very nicely explained...thanks a lot!

@ExcelU

Жыл бұрын

Thanks :)

You are rock star!.. amazing. Thanks.

@ExcelU

Жыл бұрын

Thanks Eric for your kind note ... and glad the video helped!

Good!

Important note: when you have a spreadsheet with a lot of columns: just make sure that the column with the lookup value is simply left of the column you want to search in. The Vlookup function can only search to the right! Good luck 😊

Thank you, I'm adding XLookup to my repertoire

@ExcelU

9 ай бұрын

That's great to hear!

Very nice tutorial.

@ExcelU

Жыл бұрын

Thank you :)

This is good but what if you need to lookup a value from a multi column table that has one-to-one relationships? In other words, COLUMN ONE lists values A = 1, B=2, C=3, and so on Down the column. COLUMN TWO continues on where column one left off. For example Z = 26, Z1 = 27, Z2 = 28 and so on down. Then COLUMN THREE picks up where column two left off and so on. So the lookup needs to search down column one then down column 2 then down column three etc.

Thank you Dear...but if i want to use the vlookup example but my data has only content of ( text or barcodes & total Qty), Also, some of my date are Duplicated, so, how I can use the sumifs along with Vlookup and if possible I can share with you sir my data to be an example to other in such cases.

What if I have text in two columns that need to match a condition in a range, and return a result. Ex. Column A= A, Column B=B, Range: row 1=A and B, row 2=A and C

How did you get the down arrow to pop up when highlighting the cells?

Need help on a project (that I want to do - but I am not an Excel guru) that I am in over my head, a bit ambitious excel project - but would really be a game changer for my workload. Can anyone connect to work on it? It's quite a challenge. THANKS IN ADVANCE.

Hi sir, can I have an answered about how can I solve my problem about if I input the Column A (Letter)& Column B (Number) that read the Column C (Letter Title).

well that didn't answer the question al all. you focused on adding sums rather than returning a value in column 3 if column a & B are the same as Column A & B of your sheet...

🙏🙏🙏🙏🙏

you are the fucking boss

Your formulas using Table lost me... i assume you are somehow labeling your data first?