Results 1 to 5 of 5

IF Formula / Drop Down List

Threaded View

  1. 08-09-2016, 07:27 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 use an IF Formula to pull through data based on a drop down list? Attached is an example document, what I need to know is, is it possible that if I select Scotland (worksheet 'Summary') in cell A2 that the name Mark Owen is auto populated in cell B2 and if I select South West in cell A3 that the name Jon Jones is auto populated in cell B3 etc etc?

    cheers
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. Formula for a Drop-Down List
    By dgaletar in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-04-2016, 03:45 PM
  2. IF Formula on a drop down list
    By BigSteveo in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-19-2015, 03:44 PM
  3. 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
  4. 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
  5. 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
  6. Drop down list and formula
    By DODGE in forum Excel General
    Replies: 3
    Last Post: 02-21-2009, 11:03 PM
  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