Forum Discussion

dnomyar. cramer's avatar
dnomyar. cramer
Copper Contributor
Nov 14, 2017

Is the IF function the correct function to use?

Regarding the screenshot I have attached, I need to use a function or create a formula to perform the following task:

 

The function needs to read the "Part Type" columns per row (ex. B2, D2, and F2). The result of the function should yield whichever value is highest, according to the Hierarchy List. 

Results needed to be shown:

Row2 = Motor

Row3 = Motor

Row4 = Electrical

 

(I have tried the IF and IFS functions, but have had no success.)

 

Thank you, in advance, for any insight or assistance.

Formulas & Functions
Need Help

2 Replies

  • Jihad Al-Jarady's avatar
    Jihad Al-Jarady
    MCT
    Nov 14, 2017

    Hi dnomyar,

    This is the formula you want:

    =IF(OR(B2="MOTOR",D2="MOTOR",F2="MOTOR"),"MOTOR",IF(OR(B2="ELECTRICAL",D2="ELECTRICAL",F2="ELECTRICAL"),"ELECTRICAL",IF(OR(B2="MECHANICAL",D2="MECHANICAL",F2="MECHANICAL"),"MECHANICAL","N\A")))

    • dnomyar. cramer's avatar
      dnomyar. cramer
      Copper Contributor
      Nov 14, 2017

      HUGE thank you. Thanks for taking your time to help me. It is very much appreciated.