Macro Vlookup help?
To any one who is an expert at macros in excel, I was wondering if you could help me out. I am trying to use 2 sheets to run a vlookup that will look up a customer id # and return the corresponding month associated with booking that customer from the second workbook. They are both tables. So basically I just need to look up CustomerID from sheet 1 in sheet 2 and then paste the value of the month from sheet 2 into sheet 1. This is what I have so far. We run it every month and I would like to have a quicker process if at all possible. Thanks!
Sub Vlookup()
Dim mylookupvalue As String
Dim myfirstcolumn As Long
Dim mylastcolumn As Long
Dim mycolumnindex As Long
Dim myfirstrow As Long
Dim mylastrow As Long
Dim myvlookupresult As Long
Dim previousmonth As Range
mylookupvalue = "CustID"
myfirstcolumn = 2
mylastcolumn = 15
mycolumnindex = 11
myfirstrow = 1
mylastrow = 500
With Worksheets("priormonth")
Set mytablearray = .Range(.Cells(myfirstrow, myfirstcolumn), .Cells(mylastrow, mylastcolumn))
End With
myvlookupresult = WorksheetFunction.Vlookup("CustID", sheet2, 11, False)
End Sub
corpfincorpcredit, bummer your thread hasn't had a response yet. Maybe one of these threads could point you in the right direction:
Hope that helps.
Laborum molestiae eum magni non et libero expedita. Velit assumenda sed doloribus et laborum alias.
Reprehenderit asperiores iusto praesentium eum at reiciendis dolor quis. Praesentium in tempore voluptatem corporis rem aspernatur autem. Eos inventore ipsum velit deserunt exercitationem quasi odit. Sit consequuntur exercitationem nostrum sed perferendis accusamus non quia. Adipisci vel corporis omnis praesentium.
Consequatur dolorem ipsum minus esse est nostrum voluptatem. Qui magnam enim quia occaecati deleniti. Labore iste ut culpa maiores necessitatibus.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...