+ Reply to Thread
Results 1 to 3 of 3

Lookup based on a value

  1. 05-13-2023, 06:22 PM #1
    Prascena
    Prascena is offline
    Registered User
    Join Date
    03-01-2018
    Location
    India
    MS-Off Ver
    2010
    Posts
    33

    Lookup based on a value

    Hello,

    Can you anyone please let me know how to find the column C value by formula? Attached excel as well. Thank you in advance.

    Test.JPG
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-13-2023, 07:32 PM #2
    Estevaoba
    Estevaoba is offline
    Forum Expert
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365 Version 2412
    Posts
    1,505

    Re: Lookup based on a value

    Try in C3 and drag down:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    Good luck!
    Reply With QuoteRegister To Reply
  3. 05-14-2023, 03:26 AM #3
    windknife
    windknife is offline
    Forum Expert
    Join Date
    04-14-2009
    Location
    Taiwan
    MS-Off Ver
    Excel 2016,2019,O365
    Posts
    2,868

    Re: Lookup based on a value

    C2
    =IFERROR(LOOKUP(2,1/($B1:B$2<B2),$A1:A$2),"")

    copied down.
    Attached Files Attached Files
    Last edited by windknife; 05-14-2023 at 03:46 AM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Lookup to find value based on two tables: one based on age, the other on gender
    By kbo10 in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 02-06-2022, 12:47 PM
  2. lookup based on cellvalue... without the lookup function needed
    By NoSleepForMe in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-16-2016, 04:54 AM
  3. [SOLVED] Lookup/Match from 2 worksheet & populate data based on lookup
    By plcouch in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-22-2015, 08:16 PM
  4. [SOLVED] A lookup function based on two criteria; one unique & one not unique to the lookup table
    By Trevasaurus in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-18-2014, 11:35 AM
  5. sum based on more than 2 lookup for calculation of scheme qantity based on sales quantity
    By paradise2sr in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-17-2013, 08:57 PM
  6. Returning ALL matching results based upon a text-based LOOKUP VALUE
    By colunga81 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-14-2013, 09:23 AM
  7. Sumproduct - Condition based on lookup of a Lookup
    By Hari in forum Excel General
    Replies: 13
    Last Post: 05-31-2006, 04:30 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1