Excel 2007 : Search item from list than make calculation

[pansovic]

I create Orders with for example
Pears 8
Apples 10
Orange 5
Pears 16
Now I want to create formula that calculates me 8*5+16*5 when I choose Pears and when I choose Orange 5*5, etc.
This is just one Order, other day I create for example new Order and the ranking can be different so now first comes Apples, Orange, pears, etc.

[DonkeyOte]

The question is not very clear.

What happens if you have multiple instances of Orange in addition to Pears ?

I would suggest posting a more extensive set of examples and expected results (preferably by means of a sample file).

In the meantime perhaps you want:

=SUMPRODUCT(($A$1:$A$4=$D$1)*$B$1:$B$4*SUMIF($A$1:$A$4;$D$2;$B$1:$B$4))

where A1:B4 is your table and D1 holds first value (Pears) and D2 second value (Orange)

[pansovic]

Dear DonkeyOte,
Thanks for your previous help. The issue above is as well solved but I cannot mark it as SOLVED. As you are Forum Moderator maybe you have an idea how to make this issue SOLVED?