ExcelBanter - index function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - index function (https://www.excelbanter.com/excel-worksheet-functions/449615-index-function.html)

eltyar

index function

1 Attachment(s)

Hi everyone,

please i need help to finish the below

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

sheet is attached.

thanks a lot in advance.

Claus Busch

index function

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

All times are GMT +1. The time now is 09:02 AM.