+ Reply to Thread
Results 1 to 5 of 5

Text in one cell, populates another (referencing data)

  1. #1
    Registered User
    Join Date
    07-31-2019
    Location
    Manchester, England
    MS-Off Ver
    2016
    Posts
    2

    Text in one cell, populates another (referencing data)

    Hey all,

    Hoping someone could help me with the following

    I will try explain this as best I can, keeping it short and clear.

    I have a table, the first column will be project titles. This column of cells each have a dropdown list of all the projects referenced from a second sheet.
    What I want to do is when I select a project title from the list, a second column of information to populate automatically, (such as client name).

    I hope this is clear enough and can be achieved. Please let me know if you need me to explain any further.

    Thanks for any help in advance. I really appreciate it

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    42,071

    Re: Text in one cell, populates another (referencing data)

    Welcome to the forum.

    This will be a simple VLOOKUP or INDEX MATCH:

    =VLOOKUP(A1,Sheet2!$A$1:$B$500,2,0)

    or:

    =INDEX(Sheet2!$B$1:$B$500,MATCH(A1,Sheet2!$A$1:$A$500,0))
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Registered User
    Join Date
    07-31-2019
    Location
    Manchester, England
    MS-Off Ver
    2016
    Posts
    2

    Re: Text in one cell, populates another (referencing data)

    Hi Ali,

    Thank you for your response.

    When pasting the above formulas into cell B2 onwards, excel opens up my documents folder. After closing this it leaves #N/A within the cell
    Is there something I need change within the formula?

    Sheet 1
    Attachment 635064

    Sheet2
    Attachment 635065

    Many thanks

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    10,906

    Re: Text in one cell, populates another (referencing data)

    Attempting to open either of the attachments results in the message: "Invalid Attachment specified. If you followed a valid link, please notify the administrator".
    To upload a sample workbook (not a picture or pasted copy) click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    42,071

    Re: Text in one cell, populates another (referencing data)

    Can't help as the attachments are invalid. Please attach a workbook as suggested above.

+ 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. referencing a dropdown option that populates a formula
    By CCMOM in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-02-2018, 05:44 PM
  2. [SOLVED] VBA populates cell with text some bold
    By mnadamn19 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-18-2016, 09:27 PM
  3. Input text in one cell and it populates another cell with different text
    By roseyj in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-11-2016, 03:13 AM
  4. [SOLVED] Referencing cell text data in another formula
    By Farmer Ali in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-07-2014, 06:39 AM
  5. Replies: 7
    Last Post: 02-06-2014, 07:40 AM
  6. Text Box that opens when cell is click and populates based on a lookup
    By Whirlpool in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-08-2013, 07:55 AM
  7. Replies: 2
    Last Post: 09-10-2009, 05:40 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