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.
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 😊
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
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).
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.
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.
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 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
+1
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!
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, I'm adding XLookup to my repertoire
That's great to hear!
Good explanation, thanks Paul
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 😊
🙏🙏🙏🙏thanks a lot.....that's a great value addition
How did you get the down arrow to pop up when highlighting the cells?
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
thanks paul
You are rock star!.. amazing. Thanks.
Thanks Eric for your kind note ... and glad the video helped!
Very nice tutorial.
Thank you :)
Very nicely explained...thanks a lot!
Thanks :)
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).
Thank you :)
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.
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.
Good!
great vid thanks alot
Thank you 🙏
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?