+ Reply to Thread
Results 1 to 9 of 9

show data of reference cell instead of drop-don list

  1. #1
    Forum Contributor
    Join Date
    08-04-2016
    Location
    pakistan
    MS-Off Ver
    2010
    Posts
    225

    show data of reference cell instead of drop-don list

    dear all
    PFA, i have yellow highlighted cell this is drop-down list i want when i select any figure from drop-down list, data will show of column N means if i select 4 it shows F...

    Adeel
    Attached Files Attached Files

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

    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

    Please Login or Register  to view this content.
    In column N place the following formula:

    Please Login or Register  to view this content.
    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

  3. #3
    Forum Contributor
    Join Date
    08-04-2016
    Location
    pakistan
    MS-Off Ver
    2010
    Posts
    225

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

    Hi Keebellah

    i want result in same cell instead of column N, in drop-down list cell,can it possible..??

    Adeel

  4. #4
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

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

    Quote Originally Posted by adeel1 View Post
    Hi Keebellah

    i want result in same cell instead of column N, in drop-down list cell,can it possible..??

    Adeel
    In order to make your workbook little bit arranged and nicer, the list is created on a separate sheet and put your DV on sheet1.

    See if this helps you

    Best Regards
    Imran Bhatti
    Attached Files Attached Files
    Teach me Excel VBA

  5. #5
    Forum Contributor
    Join Date
    08-04-2016
    Location
    pakistan
    MS-Off Ver
    2010
    Posts
    225

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

    thnx imran bhai
    this is good, no worry where is data pasted or arranged i need end result as my need which i got,,thnx

    Adeel

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

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

    You're welcome.

  7. #7
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

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

    Quote Originally Posted by adeel1 View Post
    thnx imran bhai
    this is good, no worry where is data pasted or arranged i need end result as my need which i got,,thnx

    Adeel
    You are welcome.

  8. #8
    Forum Contributor
    Join Date
    08-04-2016
    Location
    pakistan
    MS-Off Ver
    2010
    Posts
    225

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

    Dear imran bhai
    one more thing, can it is possible that rather i select figure from drop-down list its works like some filter means i just write zahi, all zahi starts show in cell like filter search bar...??? i just mention in file zahi250,zahi500 so on, i have similar wp250, wp500 so on...
    cell ect like filter search bar only & if someone write invlid value shows error..??pl
    Adeel
    Attached Files Attached Files
    Last edited by adeel1; 02-05-2017 at 07:28 AM.

  9. #9
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

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

    I just saw your thread again by chance.You have asked another query within the solved thread.Forum requires that if your original question is fully answered .please start new thread for new query.

+ 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] 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