+ Reply to Thread
Results 1 to 3 of 3

Match a Value with a Cell within a Range in a ROW and get the value that is directly under

  1. 12-17-2019, 02:27 PM #1
    clbargain
    clbargain is offline
    Registered User
    Join Date
    12-17-2019
    Location
    Cyprus
    MS-Off Ver
    2007
    Posts
    2

    Match a Value with a Cell within a Range in a ROW and get the value that is directly under

    Hello

    I am looking for a Function that can do the following

    Search for the word "Telephone" from A1:D1 and when you find it get the Value of the Cell that is directly underneath the cell containing the word "Telephone"

    Attachment 654280


    How can I achieve this?


    thx
    Attached Images Attached Images
    Last edited by clbargain; 12-17-2019 at 02:30 PM.
    Reply With QuoteRegister To Reply
  2. 12-17-2019, 02:32 PM #2
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Match a Value with a Cell within a Range in a ROW and get the value that is directly u

    Like so, adjust as needed to your final application:

    =INDEX(A2:D2, MATCH("Telephone", A1:D1, 0))
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)
    Reply With QuoteRegister To Reply
  3. 12-17-2019, 02:36 PM #3
    clbargain
    clbargain is offline
    Registered User
    Join Date
    12-17-2019
    Location
    Cyprus
    MS-Off Ver
    2007
    Posts
    2

    Re: Match a Value with a Cell within a Range in a ROW and get the value that is directly u

    I was doing it the other way around ! Thank you!!!
    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] Setting range located directly beneath a table
    By ddoctor in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-20-2017, 05:56 PM
  2. [SOLVED] Using code to select a cell directly below a range of an unknown size
    By LaffyAffy13 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-01-2013, 11:44 AM
  3. Insert Row directly below a named range.
    By Baziwan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-27-2013, 10:33 AM
  4. [SOLVED] Index-match link directly to excel
    By puuts in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-06-2013, 09:45 PM
  5. Populate Array directly from Non-Contiguous range cells
    By Dominicus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-16-2012, 02:52 PM
  6. Force a selected cell/range to display directly under the freeze line
    By batman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-22-2008, 01:12 PM
  7. Pointing directly to a cell in a range
    By Tomski in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-13-2006, 12:14 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1