+ Reply to Thread
Results 1 to 4 of 4

Reverse lookup. Search header/title from the data

  1. #1
    Registered User
    Join Date
    02-29-2020
    Location
    Malaysia
    MS-Off Ver
    Office 365
    Posts
    63

    Reverse lookup. Search header/title from the data

    Lookup.png

    Hi,

    In column B is the result that i need. What is the formula in column B that can lookup the title in cells D2 to F2? Column A is the condition/criteria.

    Thanks.
    Attached Files Attached Files
    Last edited by babychai; 06-10-2020 at 11:54 AM.

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    365
    Posts
    7,812

    Re: Reverse look. Search header/title from the data

    In B2 copied down
    =INDEX($D$2:$F$2,AGGREGATE(15,6,(COLUMN($D$2:$F$2)-COLUMN($D$2)+1)/($D$3:$F$6=A4),1))

  3. #3
    Registered User
    Join Date
    02-29-2020
    Location
    Malaysia
    MS-Off Ver
    Office 365
    Posts
    63

    Re: Reverse look. Search header/title from the data

    Fluff13, thank you. work great^^

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    365
    Posts
    7,812

    Re: Reverse lookup. Search header/title from the data

    You're welcome & thanks for the feedback.

+ 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] reverse lookup to get the row header
    By excelsar in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 04-25-2019, 09:44 AM
  2. [SOLVED] vlookup gives header title as search result
    By semvd in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-15-2018, 08:26 AM
  3. [SOLVED] VBA - Search Chart for Data Series Title and format.
    By rtcwlomax in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-24-2017, 09:16 AM
  4. Mail Merge problem - Header Title doesn't match data
    By shrew82 in forum Word Formatting & General
    Replies: 1
    Last Post: 08-25-2017, 09:13 AM
  5. [SOLVED] Search a sheet for a song title and return Album title
    By A440 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-28-2016, 10:19 AM
  6. [SOLVED] When filtering repeated data, leaving the title(header) alone without deleting it
    By exlgh91 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-13-2013, 12:58 PM
  7. search header name and match data in row and hight light unmatch data in colour
    By shrinivasmj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-22-2012, 07:22 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1