Business Solutions: Excel-Add Addresses With VLookup
By James D. Duncan, CPA  May 2006

 

Adding addresses to invoices is a simple task with vlookup function.  First add the customer number and information you want on the invoice.  A sample looks like this.

This very simple function will save you a lot of time.  And the accuracy is better also.  Now lets input the function in b5.  Select Insert and Functions.

Key in lookup in the Search function.  Choose the VLOOKUP and press OK.

Fill in the function as shown.

Press ok and the customer name will be in that cell based on what the value you input in B5.  Copy this to the next cell, change the column index from 2 to 3 and you have the city also.

You can add data from the table by just changing the col_index_num to read that column.  This could be used for many things.  You can look up part numbers, descriptions, sizes and many others.

Not a hard function to use once you have seen it done.  Excel has many functions that will help you.  When you have time, just look at the functions and see what you can use.

James is a member of the CCOKC and an expert in Access and Excel. Click here to reach James