Results 1 to 9 of 9

show data of reference cell instead of drop-don list

Threaded View

  1. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,937

    Re: show data of reference cell instead of drop-don list

    If you use conditional formatting you can highlight the contents of the equivalent in column M

    It applies the filled range in column M

    $L4=$I$4
    In column N place the following formula:

    =IF($I$4=$L4,M4,"")
    See attached sample
    Attached Files Attached Files
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need data to show by selecting a category in a drop down list
    By uahmed90 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-21-2015, 01:30 AM
  2. Replies: 1
    Last Post: 03-02-2015, 09:04 AM
  3. Cell reference from drop down list
    By seanpmac in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-26-2014, 07:33 PM
  4. Replies: 5
    Last Post: 04-11-2014, 03:13 PM
  5. [SOLVED] Show data with month criteria drop list (dynamic)
    By Jhon Mustofa in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-16-2014, 12:54 PM
  6. Replies: 6
    Last Post: 11-01-2013, 06:25 PM
  7. Excel 2007 : Drop down list Cell reference
    By Schibbinger in forum Excel General
    Replies: 0
    Last Post: 08-22-2011, 03:10 AM

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