Help Please

[cynder77]

the real cell refs are E3, and G3 for my first line due to titles bein
in the first 2 rows. I figured i could successfully transpose you
formula by altering the cell refs but it doesn't seem to work. Here'
what i did to your formula

=IF(E4="","",VLOOKUP(E4,$E$3:G3,3,FALSE))

I assumed you skipped the first line on the first E ref in the formul
for a reason so i carried the trend throughout and adjusted your A1 t
my E3.

Also, this cells value is used to calculate a total value based upo
the number of peices mis-shipped and this cells value, the cost pe
peice. Does this affect anything?

Thanks,
Dave Corve

 

[Bob Phillips]

The first cell is skipped because it will never be the same as previous
entry, i.e. there is no previous entry.

 

[Tom Ogilvy]

If I put the formula you show in G4 (and drag fill down the column), then it
behaves as I would expect it to. If it doesn't do what you described, then
I haven't understood what you want to do.