0

I need great help here. I want to compare two cells that are in different columns but at the same row. I need to write two different products names into two different cells and i need excel to show it to me if the entered two texts exist in the same row or not. For instance, I write 'Socks' and 'Sandals' in to two different cells, and excel shows me if they exist in the same row within two seperate columns.

Ty in advance

Improve this question
1
  • Can you show an example of your sheet?
    – yass
    May 22, 2017 at 18:58

1 Answer 1

Reset to default
0

You may have to clarify your data set setup.

One potential solution =IF(MATCH(...)=MATCH(...),"match", "no match")

Improve this answer
0

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .