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

    =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:


    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


Posting Permissions

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