#### JohnDouglas

##### Board Regular

- Joined
- Jan 5, 2005

- Messages
- 239

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