title: How to Auto-Fill a Reverse Pair Combination in Excel
body: <p>I have a spreadsheet that looks like this:</p>
  
  <p><a href="https://i.stack.imgur.com/fFeFp.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/fFeFp.png" alt="enter image description here"></a></p>
  
  <p>I am currently manually inputting my 'Y' and 'N' values into my Value column based on research.  However, to save time, I would like the value for the initial pair to be auto-filled for its reverse pairing.  For example, I gave the apple to orange pairing a value of 'Y'.  I would like to have auto-filled the orange to apple pairing with the same 'Y' value.  I thought of doing index match, but it doesn't take into consideration the combinations of pairings.  Any thoughts would be appreciated.</p>