Results 1 to 13 of 13

Nested IF ordering issue

Threaded View

  1. #1
    Registered User
    Join Date
    05-07-2012
    Location
    Pensacola, Fl
    MS-Off Ver
    Excel 2007
    Posts
    6

    Nested IF ordering issue

    Can't figure out what is wrong with this formula.

    What I need it to do:
    Look in cell C2. If C2 contains the letters "abc" anywhere in the string then 0 is the result.
    If c2 does not contain "abc" then, use lookup this table on worksheet named "data" the result is the second column.

    =IF(C2 = "*abc*", 0, IF(ISNA(VLOOKUP(I4, Data!$E$2:$F$13, 2)),0, VLOOKUP(I4, Data!$E$2:$F$13,2,)))

    The problem I am having is in the first part of the formula...when I evaluate the formula, c2 is evaluating as false when "abc" or "abcdef" is the value of c2.

    Any suggestions? Thanks.
    Last edited by dilly; 05-08-2012 at 07:45 AM.

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