Without knowing the arrangement of your data, I don't know exactly, but have
a look at VLOOKUP (or HLOOKUP).

--
Ian
--
"mspatton" wrote in message
...
I have a list of clients who all have their own Customer number. Is there
a
way to tie the name and number together so that when I type their number
into
a cell the name comes up in the cell next to it?