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!
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.
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.
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.
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
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!
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
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!
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?