+ Reply to Thread
Results 1 to 5 of 5

lookup value horizontally in a table and return value 2 cells below

  1. #1
    Registered User
    Join Date
    01-07-2013
    Location
    Mississippi
    MS-Off Ver
    Excel 2003
    Posts
    3

    lookup value horizontally in a table and return value 2 cells below

    I want to add a formula in J5 that will find the value of (G5 (which =14) in the table and return the value from 2 cells below (6322.47) Screen Shot 12-11-19 at 10.29 AM.JPG
    Last edited by gigglezallday; 12-11-2019 at 12:33 PM.

  2. #2
    Forum Expert WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    2,182

    Re: lookup value horizontally in a table and return value 2 cells below

    If those numbers are always arranged like that, you *could* cheat like this:

    Please Login or Register  to view this content.
    WBD
    Office 365 on Windows 11, looking for rep!

  3. #3
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,496

    Re: lookup value horizontally in a table and return value 2 cells below

    this works at least based on my best guess as to the cells involved...
    =IF($G$5<=13,INDEX($A$10:$M$10,MATCH($G$5,$A$8:$M$8,0)),IF($G$5<=26,INDEX($A$14:$M$14,MATCH($G$5,$A$12:$M$12,0)),IF($G$5<=39,INDEX($A$18:$M$18,MATCH($G$5,$A$16:$M$16,0)),IF($G$5<=52,INDEX($A$22:$M$22,MATCH($G$5,$A$20:$M$20,0)),""))))
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  4. #4
    Registered User
    Join Date
    01-07-2013
    Location
    Mississippi
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: lookup value horizontally in a table and return value 2 cells below

    WideBoyDixon, thank you, thank you, thank you. Worked like a charm! Best present ever...

  5. #5
    Registered User
    Join Date
    01-07-2013
    Location
    Mississippi
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: lookup value horizontally in a table and return value 2 cells below

    Thank you for the response...

+ 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] Formula to return all instances of lookup value horizontally
    By Melissa Camp in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-07-2016, 12:33 PM
  2. Return Multiple corresponding values for Single Lookup Value, Horizontally
    By ljhyun89s in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-24-2016, 06:14 PM
  3. [SOLVED] Lookup to return all possibilities horizontally
    By snikrs11 in forum Excel General
    Replies: 4
    Last Post: 10-19-2015, 03:35 PM
  4. [SOLVED] Lookup Values which meet two or more criteria and return multiple matches horizontally
    By josetmg in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-03-2015, 01:16 AM
  5. Replies: 4
    Last Post: 11-20-2014, 10:57 PM
  6. [SOLVED] Formula to lookup and return multiple results horizontally sheet 1 and 2
    By Chris1234567 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-04-2014, 11:17 AM
  7. Lookup to return multiple values horizontally
    By ROBMP in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-06-2014, 01:32 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