simplier method for if,else statement

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

Try:

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER not just ENTER. You will see {} brackets appear around the formula.

Then copy the formula down 10 rows....only matches will appear.