# Thread: How to get multiple values of Vlookup in Single Cell

1. Member
Join Date
Feb 2012
Posts
13

## How to get multiple values of Vlookup in Single Cell

I have found several items close to what i need but nothing exact. I need to perform a vlookup consisting of multiple values (names of cities) then return the sum of that result into a single cell. Is this possible? brand new to vlookup so dummy it down for me, please.

2. Member
Join Date
Nov 2010
Posts
503

## Re: How to get multiple values of Vlookup in Single Cell

Take a look SUMIF function in Help menu.

3. Member
Join Date
Nov 2010
Posts
422

## Re: How to get multiple values of Vlookup in Single Cell

But i'm seeing a return of 0 when total should be 6332; where am I going wrong with my formula : =SUMIF([PremTech.xls]Summary!\$A\$2:\$B\$117,AD8:AD16,[PremTech.xls]Summary!\$B\$2:\$B\$117)

4. Member
Join Date
Jul 2011
Posts
434

## Re: How to get multiple values of Vlookup in Single Cell

If this is what you have:
• ...........A.............B
• 1..Pittsburgh......10
• 2. Baltimore.......0
• 3..Pittsburgh......20
• 4..Cleveland......0
• 5..Cincinnati......-5

And you want to sum values that correspond to Pittsburgh: =SUMIF(\$A\$1:\$A\$5,"Pittsburgh",\$B\$1:\$B\$5) Better to use cells to hold the criteria: D1 = Pittsburgh =SUMIF(\$A\$1:\$A\$5,D1,\$B\$1:\$B\$5).

5. Member
Join Date
Aug 2011
Posts
460

## Re: How to get multiple values of Vlookup in Single Cell

I have multiple values to lookup...i.e., alpharetta, austin, bakersfield, carrollton...i want to search for all of those and return the sum into a single cell :
• City Customers
• Alpharetta 2394
• Anaheim 665
• Antioch 482
• Austin 356
• Bakersfield 794
• Boca Raton 363
• Brunswick 142
• Buena Park 339
• Canoga Park 984
• Carrollton 540