title: Find row name based on specific value in Excel
body: <p>I have a matrix dataset with values in Excel, where row and column names are identical. I have put all matrix values in a single column, but would now like a formula that returns the matching row name and/ or column name for that value. I have tried VLOOKUP and versions of INDEX and MATCH, but can't get it to work.</p>
  <p>Here's an illustration of the data:</p>
  <p><a href="https://i.stack.imgur.com/AreTS.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/AreTS.png" alt="enter image description here" /></a></p>