Results 1 to 10 of 10

Need to auto-populate cells "N/A" when selecting from a drop-down list.

Threaded View

dpeek Need to auto-populate cells... 01-08-2016, 02:04 PM
ChemistB Re: Need to auto-populate... 01-08-2016, 02:29 PM
dpeek Re: Need to auto-populate... 01-08-2016, 03:03 PM
zbor Re: Need to auto-populate... 01-08-2016, 03:56 PM
dpeek Re: Need to auto-populate... 01-08-2016, 04:08 PM
zbor Re: Need to auto-populate... 01-08-2016, 04:11 PM
tony h Re: Need to auto-populate... 01-08-2016, 04:42 PM
CAABYYC Re: Need to auto-populate... 01-08-2016, 04:46 PM
dpeek Re: Need to auto-populate... 01-12-2016, 05:25 PM
CAABYYC Re: Need to auto-populate... 01-08-2016, 04:54 PM
  1. #1
    Registered User
    Join Date
    08-17-2015
    Location
    Vancouver, WA
    MS-Off Ver
    MS Office 2013
    Posts
    6

    Need to auto-populate cells "N/A" when selecting from a drop-down list.

    Hello Forum,

    I have a need to auto-populate certain cells "N/A" when I select from a drop-down list. I know about VLOOKUP and the IF formula and have used it before, But I'm not sure if it will work in my scenario. I can't enter any formula in a cell where the "N/A"s go because depending on the drop-down selected, data may need to be entered into that cell (thus overwriting that formula).
    I attached a snip of the spreadsheet I'm working on.
    In reference to attachment... the drop-down in column C lists numbers 1-4. For example, if 3 is selected in C27, I need an N/A to populate in cells J27, T27, P27, V27.

    Is there a way make this happen? Again, I can't enter a formula into the cells that need the N/A.
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Is it possible to reverse the order in a cells "Drop Down List"?
    By ElmerFud in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-05-2015, 02:16 PM
  2. [SOLVED] Auto-populate "Yes" "No" based on multiple criteria.
    By jtmoore in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-18-2014, 09:12 AM
  3. Cmd Button to populate all drop down list on a worksheet as "Yes"
    By mike1199 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-29-2013, 02:55 PM
  4. Solution to populate cell with "X" by selecting "R"
    By nirola in forum Excel General
    Replies: 4
    Last Post: 11-17-2012, 10:15 AM
  5. Replies: 0
    Last Post: 08-30-2012, 04:39 PM
  6. Getting "like named" products to populate from drop down list
    By ssa9320 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-03-2008, 08:16 PM
  7. [SOLVED] "Create a drop-down list from a range of cells"
    By DILNAVAS in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-03-2006, 03:45 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1