I will have to thank you massively, Sir. Not only was that a great tutorial from a coding standpoint, but I also enjoyed your communication and video-style, both adding to one great educational experience. Keep up the good work, I think VBA will still remain relevant for years to come since I see tons of it in my work in the banking industry on a regular basis, and businesses will want to take advantage of the Database-enhancements/queries in Excel, which can be further advanced through VBA and so forth.
Hi Patrick - thank you for the lovely comment and I couldn't agree more with your prediction about the future of VBA. All the best and see you in another video!
For the variable chris cell, is there a way to select a range depending on the size and not a fixed range ("E6:E15")? Like for example, using vlookup in a weekly report that is different every time
Absolutely - but you'd need to dynamically define the range. Check out our video 'Position Control Mastery In Excel VBA In 13 One-Line Macros' - good luck!
Hi there - you'd need to add the workbook reference at the beginning something like: Workbooks("File Name").Sheets("List").range("A1:B5") ... and ensure the other file is open
Bryan - the only way I know to do this kind of 'double' look up is via Excel VBA, do check out our VBA beginner videos for more. Good luck and let me know how you get on.
u need just to use a range from first cell to last cell , to do thats u have to calculate the count of yours rows at the columns thats have ur lookup value ( for exemple column 1 ) 1-declare a type long 2- nb=worksheets("1").cells(rows.count,1).end(xlup).row ( this commande count the number of rows in columns 1 3-now you can use nb in range like ; sheets ("1").range ( sheets.cells(1,3),sheets.cells(nb,3) , (number 3 the columns where u want to put ur function vlookup
hi chris this vlookup vba works for the sheet to sheet or it will work for one work book to another workbook my priority of vlookup is from one workbook to another workbook i have tried the code and run the F8 i am getting run time error 1004 can we help me out
Hi there - 1004 is usually caused by a syntax error related to a sheet name or a file name. You might or might not need the file extension (eg. .xlsx) in the code. Check spelling of all sheet names and range names in the code. Good luck!
Alvin - this is not something I recommend, but is possible. You have to include the reference to the workbook in the VBA code. We have the information on our channel, or a Google search will help - good luck.
Can someone explain what he's explaining at 3:01, regarding the last two parameters of the Vlookup function? He's speaking so fast I can't interpret what he's explaining despite listening 5 times in a row.
Hi there - use 0 for the 4th part of the VLOOKUP formula when dealing with text, also known as 'discrete data'. Use 1 here when working with continuous numerical data. I do plan to do a video on this sometime - thanks for the comment!
Thanks a lot for the brilliant setup. I was wondering if you could show us how to apply the vlookup code on filtered rows. For instance, importing monthly values from report to the Master File (After implementing couple of filters to the Master Data). Best,
@@TigerSpreadsheetSolutions thanks for the reply a lot. The thing is in the master file the Product ID is listed in the column 12 times, one time for each month. This is why I need to filter the month column in the table, to fill in actual values of the month.
Hello, I find your video interesting, I think you can help me, look I have this formula: Range("D2").Select ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-2],Player10,4,FALSE)" Range("D3").Select ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-2],Player11,4,FALSE)" Range("D4").Select ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-2],Player12,4,FALSE)" Range("D5").Select ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-2],Player13,4,FALSE)" Range("D6").Select ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-2],Player14,4,FALSE)" Range("D7").Select I have this Range "D2;D14""; also the same "G2:G14" I have other Ranges, but the main thing, you see that the players change all the time, I have 18 players, I have to enter them all the time, can it be easier? So the question is, how do I do that I run? Can you please help me, with an example?
🔥WATCH NEXT
🔥EXCEL VBA ARRAYS FOR BEGINNERS
th-cam.com/video/XH2jZ7a7THM/w-d-xo.html
I will have to thank you massively, Sir. Not only was that a great tutorial from a coding standpoint, but I also enjoyed your communication and video-style, both adding to one great educational experience. Keep up the good work, I think VBA will still remain relevant for years to come since I see tons of it in my work in the banking industry on a regular basis, and businesses will want to take advantage of the Database-enhancements/queries in Excel, which can be further advanced through VBA and so forth.
Hi Patrick - thank you for the lovely comment and I couldn't agree more with your prediction about the future of VBA. All the best and see you in another video!
A new and interested subscriber from Algeria 🤗 Thank you and keep it up 👌💪
A big welcome to the channel! I hope the videos help ...
Thanks for your efforts in simplifying the information
It’s a pleasure and welcome to the channel
superb video and so easy to understand
Cheers, Lee. This one is well worth knowing I think.
For the variable chris cell, is there a way to select a range depending on the size and not a fixed range ("E6:E15")? Like for example, using vlookup in a weekly report that is different every time
Hey, did you find a solution to your question? I'm trying to figure out the same thing.
Absolutely - but you'd need to dynamically define the range. Check out our video 'Position Control Mastery In Excel VBA In 13 One-Line Macros' - good luck!
@@TigerSpreadsheetSolutions Genius. So you need to Define a range. This code will save me so much time! Thanks
If I have the List sheet in a different excel, can you please help me what to use instead of the Sheets("List") part?
Hi there - you'd need to add the workbook reference at the beginning something like:
Workbooks("File Name").Sheets("List").range("A1:B5")
... and ensure the other file is open
I would like to add another method to check if "Y" is in column B and if so then to do the rest of the code. How would I add that in?
Bryan - the only way I know to do this kind of 'double' look up is via Excel VBA, do check out our VBA beginner videos for more. Good luck and let me know how you get on.
Hello sir ,
Where I reach vba code to reference the editor doesn't give me the sheets referencing as you demonstrated
Hamza - all I can recommend is to work through the video again very carefully, paying attention to spelling and syntax ...
Hi How do I continue with next cell. I want to lookup more than 1 cell. Thank you
You would need some more complex VBA I imagine - there are many resources to learn on this channel, good luck!
u need just to use a range from first cell to last cell , to do thats u have to calculate the count of yours rows at the columns thats have ur lookup value ( for exemple column 1 )
1-declare a type long
2- nb=worksheets("1").cells(rows.count,1).end(xlup).row ( this commande count the number of rows in columns 1
3-now you can use nb in range like ; sheets ("1").range ( sheets.cells(1,3),sheets.cells(nb,3) , (number 3 the columns where u want to put ur function vlookup
Do you have a video in which you explain how to create multiple buttons which will record the values on a column when pressed any of it?
Andrei - check out our videos from 2016 / 2017. Around then I did lots of tutorials on buttons ...
@@TigerSpreadsheetSolutions Sure, I'll check now. Your videos are Gold!
hi chris
this vlookup vba works for the sheet to sheet or it will work for one work book to another workbook
my priority of vlookup is from one workbook to another workbook
i have tried the code and run the F8 i am getting
run time error 1004
can we help me out
Hi there - 1004 is usually caused by a syntax error related to a sheet name or a file name. You might or might not need the file extension (eg. .xlsx) in the code. Check spelling of all sheet names and range names in the code. Good luck!
Great Video, but can I do lookup to another workbook? not in the same file
Alvin - this is not something I recommend, but is possible. You have to include the reference to the workbook in the VBA code. We have the information on our channel, or a Google search will help - good luck.
Can someone explain what he's explaining at 3:01, regarding the last two parameters of the Vlookup function? He's speaking so fast I can't interpret what he's explaining despite listening 5 times in a row.
Hi there - use 0 for the 4th part of the VLOOKUP formula when dealing with text, also known as 'discrete data'.
Use 1 here when working with continuous numerical data.
I do plan to do a video on this sometime - thanks for the comment!
Thanks a lot for the brilliant setup. I was wondering if you could show us how to apply the vlookup code on filtered rows. For instance, importing monthly values from report to the Master File (After implementing couple of filters to the Master Data).
Best,
Hi Omar - my question is: why would you need to filter the rows at all? Since VLOOKUP should be able to find the entry you need ...
@@TigerSpreadsheetSolutions thanks for the reply a lot. The thing is in the master file the Product ID is listed in the column 12 times, one time for each month. This is why I need to filter the month column in the table, to fill in actual values of the month.
Totally brilliant
Thank you, my friend!
The tutorial was easy to understand but I get error 1004 😅
Hi Jenny - check any sheet and range names that are involved in your code. Spelling mistakes can trigger this error. Good luck!
The video is great but there is something about the sound.
Yes, I think it's a touch over-processed. I will dial it back a bit next time - thanks for the feedback.
مرسی
Bro u speak like Tyson Fury) good video, just please fix the voice and keep up)
Thank you, my friend! You're not the first to make this comparison :-)
Hello, I find your video interesting, I think you can help me, look I have this formula:
Range("D2").Select
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-2],Player10,4,FALSE)"
Range("D3").Select
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-2],Player11,4,FALSE)"
Range("D4").Select
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-2],Player12,4,FALSE)"
Range("D5").Select
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-2],Player13,4,FALSE)"
Range("D6").Select
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-2],Player14,4,FALSE)"
Range("D7").Select
I have this Range "D2;D14""; also the same "G2:G14"
I have other Ranges, but the main thing, you see that the players change all the time, I have 18 players, I have to enter them all the time, can it be easier?
So the question is, how do I do that I run? Can you please help me, with an example?