Excel Invoice, Complex Forumla

[alandrigan]

Hi Everyone,

I just put together an invoice spreadsheet for a company I would like to start and it consists of 2 worksheets

1) The actual invoice template
2) The database worksheet which contains client info, and some other dropdown list items

I have figured out all the basic drop down menus and functions. However I would like to make it so that I can select the Company Name from the invoice template worksheet from the first drop down, and based on this, I need a formula which will search the Database Worksheet and plug in the rest of the client information on the proceeding lines (address, etc etc in red)

Any and all help and direction much appreciated. Anyone is free to use this file for personal use if interested

http://www.canadianpolicing.com/HELP_TEMPLATE.xls

 

[James01]

Hi

All you need is a vlookup. For example the formula in cell A13 is

=+VLOOKUP($A$12,Database!$A$2:$I$8,2,FALSE)

Just google vlookup and you will find great resources.

 

[alandrigan]

Great thanks for the quick reply James, I will lookup this function and see if I can resolve this

cheers

 

[alandrigan]

Excellent!!

It worked without a hitch and I now have a fully working excel invoice system as well as an understanding of this new function, thanks alot James. Thumbs up!

For those who follow this thread in the future, i used this resource to learn more about the function as per directed

http://www.techonthenet.com/excel/formulas/vlookup.php