I have an exact number in cell B51. I have 10 rows of numbers (B40:B49) that one or more match B51. How can I display the Cell or Cells to the Left
(A40:A49) of the number that matches B51 if there are multiple matches for B51
------A-------------B
40--Name1----Number1
41--Name2----Number2
42--Name3----Number3
42--Name4----Number4
44--Name5----Number5
45--Name6----Number6
46--Name7----Number7
47--Name8----Number8
48--Name9----Number9
49--Name10---Number10
50
51-------------Number11
Bookmarks