TechArena Community How to get multiple values of Vlookup in Single Cell

# How to get multiple values of Vlookup in Single Cell

## MS Office Support

#1
25-02-2012
 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
25-02-2012
 Member Join Date: Nov 2010 Posts: 502
Re: How to get multiple values of Vlookup in Single Cell

Take a look SUMIF function in Help menu.
#3
25-02-2012
 Member Join Date: Nov 2010 Posts: 420
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
25-02-2012
 Member Join Date: Jul 2011 Posts: 432
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
25-02-2012
 Member Join Date: Aug 2011 Posts: 459
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

 Similar Threads for: "How to get multiple values of Vlookup in Single Cell" Thread Thread Starter Forum Replies Last Post How to combine text of multiple row in a single cell of Excel YajasK MS Office Support 2 17-02-2012 01:00 PM Excel 2010: Can VLOOKUP return multiple non-empty values from a table? marathon MS Office Support 3 21-01-2012 01:43 AM How to use VLOOKUP IF in cell that contains Text RYAN\$ MS Office Support 2 11-01-2012 04:06 PM How can I store multiple values using single button in C# Chakrika Software Development 6 26-02-2011 09:54 AM Excel : vlookup multiple values Laler Windows Software 3 25-06-2009 10:27 AM

All times are GMT +5.5. The time now is 11:05 AM.