Look at multiple cells for single matching value

[semper5]

I might be trying to reinvent the wheel, but I'm losing ground at the same time.

I am trying to get a cell to look at three individual cells, and if any of them match, return that value to to the cell. This has to happen through adjacent cells.

Does anyone have a suggestion for how to accomplish this? Without using VBA?

Thank you for your suggestions.

 

[Haseeb A]

Hello Semper,

In B4,

=IF(COUNTIF(INDEX(Balance!$K:$M,MATCH($A4,Balance!$J:$J,0),0),B$2),"X","")

Then copy across & down.

 

[semper5]

Wow!! Thank you Haseeb, Going now to study on 'Match'.

 

[semper5]

Haseeb, could you or anyone else provide me a breakdown of what this string is doing?