Thanks for working with me on this but the macro you suggest will fill column E with the vlookup formula from E2 all the way down column E for everything in column D. I need filldown to STOP in column E when it hits the first cell that already has a value in it. I just need the blank cells filled with the vlookup formula.