IF value matches, calculate ??

[kahlran]

Hi!

I'm creating a system for calculating prices.
I need a function which calculates the price, according to which item is bought, and how many.
Items are chosen from a list which I have created.

Column A = Items
Column B = Prices

D2 = Item (chosen from list)
E2 = How many
F2 = Price

Let's say one item is (chosen from list in Column A) "Teddybear". The price is 12,99$.

I want to calculate the total sum, respective to the chosen item.

So if D2 = Teddybear, take price of teddybear (defined in the cell next to item), times the amount.

Tried to explain in picture :-D

Untitled.jpg

regards,

[Fotis1991]

Nice picture but can you upload a sample worksheet?

[Spencer101]

Try this formula in cell F2

=VLOOKUP(D2,A:B,2,FALSE)*E2

[kahlran]

Try this formula in cell F2

=VLOOKUP(D2,A:B,2,FALSE)*E2

You sir, are a genious.
Worked like a charm!
Thanks alot!