MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to write the invoice as fast as posible using customer database worksheet

Posted by ÂŽeljko Jakubin on January 25, 2002 2:55 PM

Dear Mr. Excel,

I have created workskeet with my customer data as follows:
Customer data spreadskeet
Column A(code) Column B(Name) Column C(Address)
1 123456 Zeljko Jakubin Zagreb, Croatia

How to get:

when I write 123456 in B2 in Invoice spreadsheet below the Excel writes in B3 text from above Column B (Customer name)and in C5 text from above Column C (customer address) automaticaly

Invoice spreadsheet (example)

Column A Column B Column C
1 Invoice No
2 Customer ID 123456
3 Customer name Zeljko Jakubin
5 Address Zagreb, Croatia

Posted by Ed on January 25, 2002 7:34 PM

You can use the vlookup command. Vlookup the data you place in cell b2 in the database table and return the appropriate column.