LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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??
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sum of a invoice- problem with vlookup Chrisinct Excel Discussion (Misc queries) 2 December 31st 07 03:33 PM
invoice toolbar for invoice calcuation and assign number KarenY Excel Discussion (Misc queries) 15 March 16th 07 12:02 PM
vlookup and email addresses youth Excel Discussion (Misc queries) 4 October 25th 05 06:29 AM
Invoice templet Excel97 to 2003 invoice toolbar missing MarolynInMarion Excel Discussion (Misc queries) 0 August 19th 05 07:15 PM
How do I change the invoice number assigned in Invoice template... akress Excel Discussion (Misc queries) 1 February 28th 05 06:36 PM


All times are GMT +1. The time now is 09:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"