Results 1 to 4 of 4

Data validation in if statement

Threaded View

  1. #1
    Registered User
    Join Date
    05-20-2010
    Location
    tanjung pinang
    MS-Off Ver
    Excel 2007
    Posts
    7

    Data validation in if statement

    Hi...

    I am trying to put value from data validation into if statement
    e.g. if the data validation is "Jan", then formula like: =IF(Jan!11="","",Jan!F11), if i the data validation is "Feb" then the formula become like: =IF(Feb!F11="","",Feb!F11)
    so I can run it like a normal IF statement, is there a way?

    Thanks for your time...
    Last edited by mahoo; 02-15-2011 at 04:21 PM. Reason: solved

Thread Information

Users Browsing this Thread

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

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