Vlookup Multiple Values?

[AboveBeyond]

Is Vlookup or Sumif capable of having multiple lookup values?

For example.

I want vlookup to look these values: apple, oranges, grapes

So to illustrate that in a formula (even though its wrong):
Vlookup((apples,oranges,grapes),A:B,2,false)

 

[Aladin Akyurek]

Is Vlookup or Sumif capable of having multiple lookup values?

For example.

I want vlookup to look these values: apple, oranges, grapes

So to illustrate that in a formula (even though its wrong):
Vlookup((apples,oranges,grapes),A:B,2,false)

What result do you expect to see?

 

[AboveBeyond]

I guess it would more of a SumIF then a Vlookup.

Example:

Fruit - Cost
Apples - $10
Oranges - $25
Grapes - $5
Watermelons - $7
Berries - $2

Sumif Apples, oranges, and berries. This would equal (10+25+2) = $37.

I'm trying to find a way to create a sumif in one formula rather than putting mutliple sumif for each lookup value.

 

[Aladin Akyurek]

I guess it would more of a SumIF then a Vlookup.

Example:

Fruit - Cost
Apples - $10
Oranges - $25
Grapes - $5
Watermelons - $7
Berries - $2

Sumif Apples, oranges, and berries. This would equal (10+25+2) = $37.

I'm trying to find a way to create a sumif in one formula rather than putting mutliple sumif for each lookup value.

Try...

Either:

=SUM(SUMIF($A$2:$A$7,{"Apples","Oranges","Berries"},$B$2:$B$7))

Or:

=SUMPRODUCT(SUMIF($A$2:$A$7,List,$B$2:$B$7))

where List stands for a range housing the items Apples, Oranges, and Berries.

 

[AboveBeyond]

Thank you!