Results 1 to 5 of 5

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

  1. #1
    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. #2
    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. #3
    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. #4
    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. #5
    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

Similar Threads

  1. Replies: 2
    Last Post: 17-02-2012, 01:00 PM
  2. Replies: 3
    Last Post: 21-01-2012, 01:43 AM
  3. How to use VLOOKUP IF in cell that contains Text
    By RYAN$ in forum MS Office Support
    Replies: 2
    Last Post: 11-01-2012, 04:06 PM
  4. How can I store multiple values using single button in C#
    By Chakrika in forum Software Development
    Replies: 6
    Last Post: 26-02-2011, 09:54 AM
  5. Excel : vlookup multiple values
    By Laler in forum Windows Software
    Replies: 3
    Last Post: 25-06-2009, 10:27 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,659,885,497.57035 seconds with 17 queries