One way:

B1: =IF(A1=<particular number,"a name", "")

Copy down as far as necessary.

In article ,
"John" wrote:

How do I set up a function that allows for me to say that if any cell in
column a equals a particular number than another cell in that row will equal
a name?