Results 1 to 5 of 5

Data Validation with If functions

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-09-2010
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    212

    Data Validation with If functions

    Hi,

    IF functions apply into Data validation.

    IF($A$7="Company Code",C.C,xxx)

    If A7 is company code, there is an drop down list to select. If A7 doesn't company code, no need any drop down list and any value is allow to key in.
    Thus, what i should fill into XXX above.

    Attached is sample file.

    thanks
    Attached Files Attached Files
    Last edited by Shermaine2010; 09-01-2014 at 11:41 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] combining if functions and data validation to do calculations
    By petelomax in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-19-2014, 09:07 AM
  2. Help with linking data validation list and functions on multiple sheets.
    By cmcglli in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-31-2013, 09:34 PM
  3. How To Program for Data Validation With If Functions and Defaults
    By Freerider15 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-13-2011, 09:35 PM
  4. IF functions and data validation
    By VeroJade in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-30-2010, 09:02 PM
  5. Data Validation Combine Functions
    By Paul Moles in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-05-2006, 10:20 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