View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sean NWIC[_2_] Sean NWIC[_2_] is offline
external usenet poster
 
Posts: 11
Default VLOOKUP Addresses for Invoice

OK...
Here's what I want to do:

In SHEET2;
A="ID Number, B="Last Name", C="First Name", D="Address",E="City",
F="State", G="ZIP"

When I enter the "ID number" on SHEET1 in C11
In SHEET1 I want this to automatically be filled in:
C11=COLUMN "C", space, COLUMN "B"
C12=COLUMN "D"
C13=COLUMN "E"
E13=COLUMN "F"
G13=COLUMN "G"


Can you help me??