Help Please

[cynder77]

OK, I got it to work sorta. I have a ton of data i've already entere
by hand and i dont' want to lose it so i cut the existing cost data an
threw it on another tab. I put in your formula on a larger range tha
my existing data and then pasted my data back in. On my test sheet th
formula works fine if the formula is in every cell except the firs
occurence of the model but if i have manually entered data stop
autofilling reoccurrences, do i need a phantom hidden E4 cell o
something to maintain continuity?

Thanks for the help Gents.

Cheers,
Dave Corve

 

[Tom Ogilvy]

Let's say I entered the formula for the first time in row 200

=if(E200="","",vlookup(E200,$E$3:G199,3,False))
then drag fill down the column.


You adjust the formula so your fixed start location is $E$3 and your ending
location is column G of the preceding row.