View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kane Kane is offline
external usenet poster
 
Posts: 14
Default VLOOKUP for lookup of names in address tables

I have an excel table containing name address and phone number.

I would like to enter a name in one cell and have another cell display the
phone number for that name from the table. I think vlookup can do this, but
I am having diffculties getting it to work.

Please post any formula suggestions that should make this work. Thanks.