+ Reply to Thread
Results 1 to 4 of 4

Adding drop down box values in a IF statement...

  1. #1
    Registered User
    Join Date
    12-06-2015
    Location
    Michigan
    MS-Off Ver
    Office 365
    Posts
    79

    Post Adding drop down box values in a IF statement...

    How do you add items from a drop down box to a IF statement? Example:

    Drop Down Box: 1,2,3,4,5
    I tired something similar to this formula: IF(A1="1,2,3,4,5",Vlookup(B1,C1:D5,2,FALSE))

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Adding drop down box values in a IF statement...

    Maybe something like this...

    =IF(OR(A1={1,2,3,4,5}),VLOOKUP(B1,C1:D5,2,0),"")
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Registered User
    Join Date
    12-06-2015
    Location
    Michigan
    MS-Off Ver
    Office 365
    Posts
    79

    Re: Adding drop down box values in a IF statement...

    Quote Originally Posted by Tony Valko View Post
    Maybe something like this...

    =IF(OR(A1={1,2,3,4,5}),VLOOKUP(B1,C1:D5,2,0),"")
    This one didn't work. Thanks for the quick reply.

  4. #4
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Adding drop down box values in a IF statement...

    Works for me.

    Maybe this version:

    =IF(OR(A1={"1","2","3","4","5"}),VLOOKUP(B1,C1:D5,2,0),"")

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Adding values when particular Drop Down items are selected
    By cdsmith8888 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-10-2014, 04:43 PM
  2. Replies: 10
    Last Post: 02-03-2012, 11:10 AM
  3. Replies: 5
    Last Post: 03-01-2011, 11:02 AM
  4. Replies: 2
    Last Post: 11-08-2010, 10:45 AM
  5. Adding Values to Drop Down Menu Text Options
    By Hammie in forum Excel General
    Replies: 3
    Last Post: 05-08-2010, 03:05 PM
  6. Problems with IF statement when adding invoice values
    By Darlo in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-26-2009, 12:15 PM
  7. adding a drop down list to an If Statement?
    By robc in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-13-2006, 05:10 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1