Vlookup fill down blank cells in column

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Vlookup fill down blank cells in column

FAQ

Thread Tools

Display Modes

09-23-2016, 11:11 AM

NoSparks

Windows 7 64bit Vlookup fill down blank cells in column

Office 2010 64bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Auto Fill only Blank Cells in a Column	mbesspiata3	Excel Programming	1	09-22-2016 07:18 PM
Return Sum value of one column from cells not blank in another column	zulugandalf	Excel	3	08-14-2014 03:37 AM
How-TO format cells (FILL) by comparing cells	zanat0s	Excel	1	07-03-2012 04:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:31 PM.