+ Reply to Thread
Results 1 to 7 of 7

How to Vlookup from two input with multiple ranges ?

  1. #1
    Registered User
    Join Date
    06-25-2014
    Location
    qatar
    MS-Off Ver
    2010
    Posts
    4

    How to Vlookup from two input with multiple ranges ?

    I am looking for the formulae in E9.

    I may change the value in E8 as 1.5 or 2.5 or 4 or 6
    I may scrolldown C9 as it set out there. I need to know the farmulae in E9.

    Thank you
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    10-06-2008
    Location
    Norway
    MS-Off Ver
    2010
    Posts
    365

    Re: How to Vlookup from two input with multiple ranges ?

    Hi, try:
    '=VLOOKUP(C9,D23:H26,LOOKUP(E8,E22:H22;{2,3,4,5}),FALSE)

  3. #3
    Registered User
    Join Date
    06-25-2014
    Location
    qatar
    MS-Off Ver
    2010
    Posts
    4

    Re: How to Vlookup from two input with multiple ranges ?

    Estige,
    Many thanks for your great help.
    But it turns error formulae , any function is missed out ?

  4. #4
    Valued Forum Contributor
    Join Date
    10-06-2008
    Location
    Norway
    MS-Off Ver
    2010
    Posts
    365

    Re: How to Vlookup from two input with multiple ranges ?

    Hi, probably something gone wrong in my manual translation to English syntax. OK in the attached workbook?
    Attached Files Attached Files

  5. #5
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: How to Vlookup from two input with multiple ranges ?

    Try this,
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    06-25-2014
    Location
    qatar
    MS-Off Ver
    2010
    Posts
    4

    Re: How to Vlookup from two input with multiple ranges ?

    Estige,
    you deserve excel expert.
    Thank you so much.
    I too not an english man.

  7. #7
    Registered User
    Join Date
    06-25-2014
    Location
    qatar
    MS-Off Ver
    2010
    Posts
    4

    Re: How to Vlookup from two input with multiple ranges ?

    Thank you kvsrinivasamurthy for your support and timings.
    It works

+ 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. vlookup multiple ranges
    By 13lack13lade in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-01-2014, 10:18 PM
  2. Replies: 3
    Last Post: 10-18-2012, 04:45 AM
  3. Can a =vlookup() consider multiple ranges of criteria?
    By MacroPolo in forum Excel General
    Replies: 3
    Last Post: 08-01-2012, 05:07 PM
  4. Vlookup in a macro for multiple ranges, Help?
    By ad9051 in forum Excel General
    Replies: 5
    Last Post: 12-05-2010, 06:48 AM
  5. multiple ranges on Vlookup
    By lpj in forum Excel General
    Replies: 19
    Last Post: 01-11-2006, 01:50 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