+ Reply to Thread
Results 1 to 2 of 2

Lookup a value in a range based off another value

  1. #1
    Registered User
    Join Date
    02-14-2022
    Location
    USA
    MS-Off Ver
    2021
    Posts
    1

    Lookup a value in a range based off another value

    Trying to find the value from Table1ColumnB from the ranges in Table2ColumnB,Table2ColumnC, by first matching the values from Column A.

    Table 1
    A B Result (what I need)
    1 120 boop
    3 140 blam
    4 220 beep
    1 190 boop


    Table 2 (lookup table)
    A B C Return (what I want to extract)
    1 100 200 boop
    2 200 300 bap
    3 100 200 blam
    4 200 300 beep

    Any help is greatly appreciated.
    I've tried running an xlookup within an if statement, but finding it difficult to match it up.


    APOLOGIES:
    This was resolved using the formula presented by Pete_UK in the post: "Lookup Formula Based on Range" by XCEL123
    =INDEX($D$2:$D$6,MATCH(1,(F2=$A$2:$A$6)*(G2>=$B$2:$B$6)*(G2<$C$2:$C$6),0))
    Last edited by Nemo_Slumbers; 02-14-2022 at 09:17 PM.

  2. #2
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    China Shanghai
    MS-Off Ver
    365 V2402 and WPS V2022
    Posts
    3,327

    Re: Lookup a value in a range based off another value

    Other option
    Cell H2 formula , Drag down

    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ 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] Update Range based on Lookup Value
    By skydivetom in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-31-2021, 11:00 AM
  2. [SOLVED] Lookup Formula Based on Range
    By XCEL123 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-05-2021, 03:50 PM
  3. Lookup Based on Range
    By bbogner in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-14-2017, 07:39 PM
  4. [SOLVED] Lookup value based on range and unique ID
    By Prince Dakkar in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-25-2014, 09:41 AM
  5. lookup value based on date range
    By shcsbaker in forum Excel General
    Replies: 4
    Last Post: 06-11-2014, 01:01 PM
  6. lookup and return a value based on a range
    By mamig in forum Excel General
    Replies: 2
    Last Post: 03-25-2011, 12:50 PM
  7. [SOLVED] Lookup based on range of dates
    By dls2193 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-30-2006, 06:25 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1