+ Reply to Thread
Results 1 to 2 of 2

Simpler formula for IF statement?

  1. #1
    Registered User
    Join Date
    07-05-2011
    Location
    Scotland
    MS-Off Ver
    Excel 2003
    Posts
    74

    Simpler formula for IF statement?

    I have a speadsheet which is currently set up to enter a value in column A based on the text in Column G - unless the text in column G is 'complete', 'blocked' or 'duplicate', in which case the related cell in column A remains blank.

    I am using the following IF statement which references a worksheet called 'vlookup':

    =IF(G33="complete"," ",IF(ISNA(VLOOKUP(D33,Vlookup!$G$3:$H$152,2,FALSE))," ",IF(G33="BLOCKED"," ",IF(ISNA(VLOOKUP(D33,Vlookup!$G$3:$H$152,2,FALSE))," ",IF(G33="duplicate"," ",IF(ISNA(VLOOKUP(D33,Vlookup!$G$3:$H$152,2,FALSE))," ",(VLOOKUP(D33,Vlookup!$G$3:$H$152,2,FALSE))))))))

    This does work but I wondered if there is a simpler way of doing this.

    Thanks

    Glayva

  2. #2
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Simpler formula for IF statement?

    I don't recommend using function names for sheet names, so in your formula, I used "Sheet2" instead. Otherwise, try this formula:

    Please Login or Register  to view this content.
    Cheers,
    Last edited by ConneXionLost; 08-03-2011 at 12:05 PM.
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

+ Reply to Thread

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