• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

IF Function Formula

ridwanr

New Member
Hi all,

I have a table of two month January and February with with ID number, Country and Colors..

I want an if function which indicates me in month February if the colors is the same as in both month it should indicates "Correct" but if the color differ it should indicate "Do not exist"

Please see attached doc for better understanding.

Thanking you for your help in advance.

Kind regards,
Ridwan
 

Attachments

Peter Bartholomew

Well-Known Member
A complete rundown for a combined list?
76508
Code:
= LET(
    JanColour, XLOOKUP(Country, January[Country], January[Colors], ""),
    FebColour, XLOOKUP(Country, February[Country],February[Colors],""),
    IFS(
      JanColour="", Country & " not found in January",
      FebColour="", Country & " not found in February",
      JanColour=FebColour, "Correct. Colour:"&JanColour,
      TRUE, "Does not exist. Options:"&JanColour&"/"&FebColour))
 

ridwanr

New Member
A complete rundown for a combined list?
View attachment 76508
Code:
= LET(
    JanColour, XLOOKUP(Country, January[Country], January[Colors], ""),
    FebColour, XLOOKUP(Country, February[Country],February[Colors],""),
    IFS(
      JanColour="", Country & " not found in January",
      FebColour="", Country & " not found in February",
      JanColour=FebColour, "Correct. Colour:"&JanColour,
      TRUE, "Does not exist. Options:"&JanColour&"/"&FebColour))
Thanks
 
Top