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.

--
Regards,
Tom Ogilvy

"cynder77" wrote in message
...

the real cell refs are E3, and G3 for my first line due to titles being
in the first 2 rows. I figured i could successfully transpose your
formula by altering the cell refs but it doesn't seem to work. Here's
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 formula
for a reason so i carried the trend throughout and adjusted your A1 to
my E3.

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

Thanks,
Dave Corvec


--
cynder77
------------------------------------------------------------------------
cynder77's Profile:
http://www.excelforum.com/member.php...o&userid=15371
View this thread: http://www.excelforum.com/showthread...hreadid=269915