+ Reply to Thread
Results 1 to 3 of 3

If Blank using Match and Index

  1. #1
    Forum Contributor
    Join Date
    12-21-2004
    Location
    MN
    MS-Off Ver
    Microsoft 365
    Posts
    211

    If Blank using Match and Index

    How do I add a statment to this formula to say:
    If I5 is blank, do nothing...otherwise do what the code says below?
    I tried adding it in different ways but it doesn't work.

    =IF(ISNA(MATCH(I5,code,0)),"-",INDEX(description,MATCH(I5,code,0)))

  2. #2
    Banned User!
    Join Date
    10-14-2006
    Posts
    1,211
    =IF(I5="","",IF(ISNA(MATCH(I5,code,0)),"-",INDEX(description,MATCH(I5,code,0))))

  3. #3
    Forum Contributor
    Join Date
    12-21-2004
    Location
    MN
    MS-Off Ver
    Microsoft 365
    Posts
    211
    AWESOME! Thank you!

+ 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