Hello sir. It was an excellent video. I have one doubt. What if I need vloopup on two separate sheet? I mean I need vlookup three values to an another sheet which has same values. The data is almost 70000 entries. Thanks!
Thank you very much sir.You really helped me but unfortunately I still have a small problem . ,Why you wrote () row minus 1 ? you also higlithed "row' clicked F9. ,Ii couldn't see how it returned to row..... hank you very much
Hi Charles, we use row () to get us the row number, and since the formula is in Row 2 , when using the row function it will give us 2 , but we need 1 for the first Vlookup entry, so we minus 1 to get 1. Hope this is clear. Enjoy...Join my course on Udemy to learn more Advanced stuff..
Subscribe for more videos !!
I changed it a bit to adjust to my query but worked perfectly nice job.
I've been looking for this solution! Thank You!
Glad I could help😊
Thank you for this help... How did you added drop down function at 06:05
Great Video, you have helped me solved what seemed to be impossible at first
Glad I could help!
How do we use ROW if the table is on another sheet?
Hello sir. It was an excellent video. I have one doubt. What if I need vloopup on two separate sheet? I mean I need vlookup three values to an another sheet which has same values. The data is almost 70000 entries. Thanks!
I will try to make a video on that
Hello sir I am waiting for the new video@@myexcelacademy69
Short list ki beena bhi is formula nhi lg skta hai kyaa
It was very informative but i need to know how can i get all the sales value of chris summed up in 1 row?
Just add one row on top and use the SUM function
Life saver dude.. Thanks a lot
Thank you very much sir.You really helped me but unfortunately I still have a small problem . ,Why you wrote () row minus 1 ? you also higlithed "row' clicked F9. ,Ii couldn't see how it returned to row.....
hank you very much
Hi Charles, we use row () to get us the row number, and since the formula is in Row 2 , when using the row function it will give us 2 , but we need 1 for the first Vlookup entry, so we minus 1 to get 1. Hope this is clear. Enjoy...Join my course on Udemy to learn more Advanced stuff..
@@myexcelacademy69 hello sir, please can you explain on this why you minus 1 when the row you've used is in row 3?
Very useful! Thank you
Glad to hear that!
Can you teach online excel formulas please
www.udemy.com/course/mba-in-excel-master-business-analytics-in-excel/?couponCode=85D50BE60F145DFBFB12
Hy i have a question
jazakaallah
Nice brother
filter function can easily do same thing
Yes, but not everybody has office 365
Thx for the tutorial.
excellent, thank you so much
How pick at put down
Why didn't i watch this before my interview 😢
Super
Without drop down list ke formula kese aply kre
Thanks sir, understood-shivsharan
Thenks Sir
Welcome dear
How to skip to next column when sales column value contain 0
I mean Chris 10, Chris 0, Chris 30, then i want to get result as - Chris 10, 30, etc
Wow
Бале екенсің, қара бет😂
First