Consider using the VLOOKUP() function.
--
Gary''s Student - gsnu200734


" wrote:

I am constantly entering client names and number in an excel
spreadsheet and would like to know if there is a way to have the
client name show up after entering the client number. I would have a
master sheet that contains a list of all clients. Thanks for your help!