+ Reply to Thread
Results 1 to 6 of 6

IF Formula / Drop Down List

  1. 08-09-2016, 06:47 AM #1
    jonconc
    jonconc is offline
    Registered User
    Join Date
    04-08-2010
    Location
    Mountain ash
    MS-Off Ver
    Excel 2010
    Posts
    13

    IF Formula / Drop Down List

    Hi,

    Is it possible to create an IF Formula that will auto populate a cell based on the information contained within another cell that has been populated via a drop down list? Attached is an example of what I need - On the worksheet 'Summary' column A is a drop down list, based on the information within it can column B auto populate? For instance is Scotland is selected in cell A2 is it possible for the name Mark Owen to appear in cell B2 and if South West is selected in cell A3 that the name Jon Jones appears in cell B3?

    Cheers
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-09-2016, 06:51 AM #2
    isskint
    isskint is offline
    Registered User
    Join Date
    06-21-2013
    Location
    Wiltshire, UK
    MS-Off Ver
    365 Version 2210 Build 16.0.15726.20070
    Posts
    72

    Re: IF Formula / Drop Down List

    That could be as simple as a Vlookup() function. Enter the formula in B2, B3 etc. Depending on your settings, this formula should copy down for new rows. Alternatively make your data into a table and then the formula WILL always reproduce on a new row
    Attached Files Attached Files
    Isskint, i get satisfaction out of helping others
    Reply With QuoteRegister To Reply
  3. 08-09-2016, 06:52 AM #3
    Pete_UK
    Pete_UK is offline
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,733

    Re: IF Formula / Drop Down List

    Put this formula in B2:

    =VLOOKUP(A2,'Drop Down'!A:B,2,0)

    then copy down.

    Hope this helps.

    Pete
    Reply With QuoteRegister To Reply
  4. 08-09-2016, 06:58 AM #4
    sanram
    sanram is offline
    Valued Forum Contributor
    Join Date
    06-21-2013
    Location
    Bangladesh
    MS-Off Ver
    Excel 2000, Excel XP, Excel 2002, Excel 2007, Excel 2010, Excel 2013
    Posts
    975

    Re: IF Formula / Drop Down List

    You can use Index Match also. Write the following formula in B2 of Summary and then copy down.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 08-09-2016, 08:23 AM #5
    jonconc
    jonconc is offline
    Registered User
    Join Date
    04-08-2010
    Location
    Mountain ash
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: IF Formula / Drop Down List

    Cheers Jon
    Reply With QuoteRegister To Reply
  6. 08-09-2016, 08:26 AM #6
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: IF Formula / Drop Down List

    You're welcome. We appreciate the feedback!

    If your question has been solved please mark the thread as being solved.

    In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

    It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.
    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. Populate Drop-down list based on selection from previous drop-down list
    By Diventus in forum Excel - New Users/Basics
    Replies: 14
    Last Post: 01-11-2013, 10:55 AM
  2. Populate Drop-down list based on selection from previous drop-down list
    By poison_stone in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 12-11-2012, 06:10 PM
  3. Choosing a worksheet with drop down list then selecting data with another drop down list
    By MTAZ in forum Excel General
    Replies: 3
    Last Post: 04-16-2012, 10:14 PM
  4. drop down list formula
    By bayheating in forum Excel General
    Replies: 1
    Last Post: 10-07-2009, 05:40 PM
  5. Drop-down list formula
    By arachai in forum Excel General
    Replies: 5
    Last Post: 11-16-2007, 12:49 PM
  6. drop down list formula's
    By davittp in forum Excel General
    Replies: 5
    Last Post: 08-01-2007, 06:05 AM
  7. multiple select from the drop down list in excel. list in one sheet and drop down in
    By sriramus in forum Excel General
    Replies: 5
    Last Post: 10-27-2005, 01:55 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