I forgot to tell you that the formula is an ARRAY formula. Once you type in
the formula hit CLT+SHIFT+Enter
--
Thank you,

scrowley(AT)littleonline.com


"IanC" wrote:

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?