Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to get multiple values of Vlookup in Single Cell

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 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.

Reply With Quote
  #2  
Old 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.
Reply With Quote
  #3  
Old 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)
Reply With Quote
  #4  
Old 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).
Reply With Quote
  #5  
Old 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
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


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.