If you have lots of names, it may be better to create a 2 column table on
another sheet (and hide that sheet???).

Then you could use this kind of formula:

=if(a1="","",vlookup(a1,sheet2!a:b,2,false))

And to avoid looking at errors when there isn't a match:

=if(a1="","",if(iserror(vlookup(a1,sheet2!a:b,2,fa lse)),"Missing Name",
vlookup(a1,sheet2!a:b,2,false)))

Debra Dalgleish has lots of notes on =vlookup():
http://www.contextures.com/xlFunctions02.html

frederick wrote:

hello, i would like to set up something like this: if name = a then address =
x, if name = b then address = y,....
i work with 2 sheets, 1 for invoices 1 for contents or datas

--

Dave Peterson