ExcelBanter - Help with Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Help with Formula (https://www.excelbanter.com/excel-programming/393646-help-formula.html)

Help with Formula

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!

Gary''s Student

Help with Formula

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!

All times are GMT +1. The time now is 10:38 PM.