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

--
cynder7
-----------------------------------------------------------------------
cynder77's Profile: http://www.excelforum.com/member.php...fo&userid=1537
View this thread: http://www.excelforum.com/showthread.php?threadid=26991