Hi,

Am Sat, 14 Dec 2013 13:51:35 +0000 schrieb eltyar:

need function in "Total" column to look in "Destination" column and take
the "price" automatically from information data to give me
"Weight*DestinationPrice=Total".

in C3 try:
=A3*VLOOKUP(B3,$G$3:$H$6,2,0)
and copy down


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2