Results 1 to 4 of 4

Thread: IF Formula checking for Text

  1. #1

    IF Formula checking for Text



    Register for a FREE account, and/
    or Log in to avoid these ads!

    =IF('EQUIPMENT LIST'!I6<="Motor Control Center",'EQUIPMENT LIST'!E6,"")

    I am trying to retrieve a value from column E(any cell) where any cell in the I column = "Motor Control Center".

    I have tried various conditions such as:

    =
    <>
    <=

    The results are not correct. It seems to me the above should work.

  2. #2
    Try

    =IF(COUNTIF('EQUIPMENT LIST'!I6,"Motor Control Center"),'EQUIPMENT LIST'!E6,"")

  3. #3
    OK the above worked for me now I have another formula that I am working on:

    =IF((or(LEFT(B3,4)="MCC-","MVMC"),B3,"")

    I am checking for two specific text values in a cell and only checking the first 4 bytes. I keep getting either the word *VALE* or *NAME*, what am I doing or not doing correctly?

  4. #4
    Use

    =IF(OR(LEFT(B3,4)="MCC-",LEFT(B3,4)="MVMC"),B3,"")

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •