Results 1 to 2 of 2

Thread: Lookup multiple values in excel

  1. #1
    Join Date
    Dec 2009
    Posts
    2

    Lookup multiple values in excel

    I'm trying to use excel to lookup multiple values and add them together. I want to be able to put the range in two cells then get the corresponding values on the table for two numbers at the ends of the range and all of them in between.

    For example, I would like to be able to put a 1 in one box and a 5 in the other box then have lookup get all the values from the table for 1, 2, 3, 4, and 5 then add them together. Is there any way to do this?

  2. #2
    Join Date
    Dec 2009
    Posts
    2

    Re: Lookup multiple values in excel

    nevermind. figured out I can just use =SUM(INDIRECT("Sheet8!B"&A1):INDIRECT("Sheet8!B"&A2))

Similar Threads

  1. EXCEL Lookup the same value that has multiple values
    By horse43 in forum Windows Software
    Replies: 1
    Last Post: 09-06-2012, 11:42 AM
  2. Replies: 5
    Last Post: 27-10-2009, 12:40 AM
  3. Excel : vlookup multiple values
    By Laler in forum Windows Software
    Replies: 3
    Last Post: 25-06-2009, 10:27 AM
  4. Help-How to select multiple values using lookup function???
    By shivinder in forum Microsoft Project
    Replies: 3
    Last Post: 24-03-2009, 10:20 PM
  5. Problem in Charting multiple values in Excel
    By Memnon in forum Software Development
    Replies: 2
    Last Post: 02-01-2009, 08:17 PM

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,642,395,484.08372 seconds with 17 queries