Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP Addresses for Invoice
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. "Sean NWIC" wrote: 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?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum of a invoice- problem with vlookup | Excel Discussion (Misc queries) | |||
invoice toolbar for invoice calcuation and assign number | Excel Discussion (Misc queries) | |||
vlookup and email addresses | Excel Discussion (Misc queries) | |||
Invoice templet Excel97 to 2003 invoice toolbar missing | Excel Discussion (Misc queries) | |||
How do I change the invoice number assigned in Invoice template... | Excel Discussion (Misc queries) |