Thread: [Solved] Vlookup fill down blank cells in column
View Single Post
 
Old 09-23-2016, 11:11 AM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default
give this a try
Code:
Range("E2").FormulaR1C1 = _
    "=VLOOKUP(RC[-1],'[CBP Port and Other Agency Listing.xlsx]Combined'!C4:C5,2,FALSE)"
Range("E2:E" & Cells(2, "E").End(xlDown).Row - 1).FillDown
Reply With Quote