Hi there
Could someone pls help me withe following:

Odd Even
1 2
3 4
5 6
7 8
9 10

In cell F1 i have the following function to show the matching number entered by the user in E1.
=IFERROR(INDEX(A2:A5,MATCH($E$1,B2:B5,0)),INDEX(B2:B5,MATCH($E$1,A2:A5,0)))

this works but when a non listed number is entered or blank in cell F1, it shows #N/A.
How could I fix or perhaps have a shorter function that meet the purpose.
Excuse my ignorance, my 1st post!
Aib