index function

[eltyar]

Hi everyone,

please i need help to finish the below

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

sheet is attached.

thanks a lot in advance

+-------------------------------------------------------------------
|Filename: ex.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=934
+-------------------------------------------------------------------

 

[Claus Busch]

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.