Index Match Formula to include Matches from one cell or other(s) please

I have the following formula in A1 Sheet1

=INDEX('Sheet2'!$A$2:$A$200,MATCH(C2,'Sheet2'!$E$2:$E$200,0))

With someones help I'd like to expand the Formula so that it considers also Matches down additional Columns of Sheet2 please?

For instance if a Match wasn't down column E of Sheet2, the Formula returns #N/A, but there maybe an alternative spelling down column F, G, or H of Sheet2?

So, all Columns do not have to Match, just the contents of one of them, be it E, F, G, H etc.

Thank you

Try it like this:

=IFERROR(INDEX('Sheet2'!$A$2:$A$200,IFERROR(MATCH(C2,'Sheet2'!$E$2:$E$200,0),IFERROR(MATCH(C2,'Sheet2'!$F$2:$F$200,0),IFERROR(MATCH(C2,'Sheet2'!$G$2:$G$200,0),MATCH(C2,'Sheet2'!$H$2:$H$200,0))))),"")

Hope this helps.

Pete

Thank You Pete, much appreciated.

Kind regards

Pete!