IFERROR & OR With Multiple Results

[Frenzyy]

Hi, I'm using the below formula to retrieve whether or not two values (e.g. A2 & E1) are found next to one another. Thing is though, while I'm getting the correct results, i.e. "TRUE" for all necessary cells, I've no way to distinguish which part of the 'OR' was triggered.
For example, I'd like to get "Result1" when the first loop equals TRUE and "Result2" for the second.

Please Login or Register  to view this content.

Hope the explanation makes sense but please don't hesitate to ask.

Many thanks!

[Pepe Le Mokko]

Post a sample sheer ( see yellow banner)

[Frenzyy]

Actually, never mind anymore as I just ended up using a helper column.

Thanks!