View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
xololady xololady is offline
external usenet poster
 
Posts: 9
Default vlookup for client list

I am working on a billing spreadsheet. Each client has a client ID plus
other details over 11 columns. I created client list with their specific
info. When I try to use a VLOOKUP formula on new worksheet, I can only get
client ID and name (first 2 columns) without the other columns. I want to be
able to type client id number and have the rest of the info automatically
fill in the row. Please tell me what I am missing.

Thank you, Karen