title: How do I find a closest number in Excel and bring back a corresponding cell?
body: <p>Row 1 :  YORK / LEEDS / WINDSOR / CHESHIRE</p>
  
  <p>Row 2 :   10 /   8    /    6 /    9</p>
  
  <p>So I want to find the closest match to York in the other data across each row, and bring back the title of the closest match.</p>
  
  <p>So the answer i want to bring back for row 2 (York = 10) is "CHESHIRE" as 9 is the closest to 10.</p>
  
  <p>Thank you!</p>