View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default how do i setup IF name = this then address = that

On Sat, 19 Aug 2006 04:58:01 -0700, 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


Set up a table and use VLOOKUP
--ron