JohnDouglas
Board Regular
- Joined
- Jan 5, 2005
- Messages
- 239
Hi guys
ok, thanks giving today but hopefully there's still enough people around to help with this
I have the following data in two columns.
apples 2
bananas 5
total cost ????
then in another sheet i have the vlookup up table
apples £300
bananas £400
any ideas what forumla i could put in the "total cost ?????" that would sum the total cost of purchasing all the apples and bananas?
thanks for your help
john
ok, thanks giving today but hopefully there's still enough people around to help with this

I have the following data in two columns.
apples 2
bananas 5
total cost ????
then in another sheet i have the vlookup up table
apples £300
bananas £400
any ideas what forumla i could put in the "total cost ?????" that would sum the total cost of purchasing all the apples and bananas?
thanks for your help
john