+ Reply to Thread
Results 1 to 7 of 7

Vlookup or index

  1. #1
    Registered User
    Join Date
    12-27-2014
    Location
    Doha
    MS-Off Ver
    2011
    Posts
    5

    Vlookup or index

    excel.png

    I am trying to figure out which formulas to use in order to get value1 and value2 from the table on top. Also, a formulas to print the range of numbers between value1 and value2 in the result cells.
    for value1 and value2 I tried vlookup and index but I am getting error #ref and #value. Regarding result cell, I couldn't manage to find anything that can print the result.
    Thank you.
    Gaby
    Last edited by softice; 12-27-2014 at 04:25 AM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    30,754

    Re: Vlookup or index

    Hi. That's better...

    So. I understand the first part of your question and i have an answer. What i don't fully understand is what you want in the RESULT box.

    this formula will ONLY work if the values in the 2D matrix are UNIQUE. if they are not, please let me know and I will go away again and see what I can come up with...
    Attached Files Attached Files
    Glenn



  3. #3
    Registered User
    Join Date
    12-27-2014
    Location
    Doha
    MS-Off Ver
    2011
    Posts
    5

    Re: Vlookup or index

    Thank you for your prompt reply,
    the result is the range of numbers between value1 and value2. In the example above, value1=1007 and value2=1010 so the result must show the range result= 1007, 1008, 1009, 1010.
    if for example value1 = 1007 and value 2=1007, the result = 1007 (only). if value1=1007 and value2 =1008, the result = 1007,1008. It is only showing the range of the numbers of v1 and v2. It will be only printing the numbers as a reference of which to use.
    I hope I made myself clear.
    Thank you again.

  4. #4
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,614

    Re: Vlookup or index

    If you are open to a VBA solution, please find the attached sheet and click on the Yellow Button to get the desired output.
    Attached Files Attached Files
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  5. #5
    Registered User
    Join Date
    12-27-2014
    Location
    Doha
    MS-Off Ver
    2011
    Posts
    5

    Re: Vlookup or index

    Thank you sktneer,

    your solution solved my problem, but unfortunately I don't have good knowledge about VBA. thanks anyway

  6. #6
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    2,249

    Re: Vlookup or index

    Another try with formula

    regards
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    12-27-2014
    Location
    Doha
    MS-Off Ver
    2011
    Posts
    5

    Re: Vlookup or index

    Thank you azumi,
    your formula is perfect and solved my problem.
    regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Need Formulas to Hide Partial Concatenate Data and Help Determining Two Other Formulas
    By Mattdim805 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-13-2013, 04:11 PM
  2. Using Cell references in file paths for formulas to create dynamic formulas
    By MichaelStokesJr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-04-2013, 11:49 AM
  3. Insert cells, fill formulas down, set formulas for dynamic range
    By Snickers65 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-03-2013, 01:43 PM
  4. Replies: 5
    Last Post: 09-25-2013, 02:51 PM
  5. Replies: 5
    Last Post: 05-05-2008, 02:22 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1