VLOOKUP Addresses for Invoice

[Sean NWIC]

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??

 

[JLatham]

To begin with, you won't be able to put your ID number into C11 on Sheet 1
*and* have a formula that returns a value from sheet2, so let's pick another
cell at least for this example. I'll pick A11. Also assuming the table on
Sheet2 goes from row 2 down to row 99.

In C11
=VLOOKUP(A11,Sheet2!$A$2:$G$99,3,FALSE) & " " &
VLOOKUP(A11,Sheet2!$A$2:$G$99,2,FALSE)
in C12
=VLOOKUP(A11,Sheet2!$A$2:$G$99,4,FALSE)
in C13
=VLOOKUP(A11,Sheet2!$A$2:$G$99,5,FALSE)
in E13
=VLOOKUP(A11,Sheet2!$A$2:$G$99,6,FALSE)
in G13
=VLOOKUP(A11,Sheet2!$A$2:$G$99,7,FALSE)

Hope this helps.