| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I have a cell fill in addresses from another file when I t.
I have my invoices in Excel. I want to be able to type in the name of the
client, and have it automatically fill in the address. Any help out there? Thanks. |
|
#2
|
|||
|
|||
|
sounds like you need a simple vlookup.
"Cbrat" wrote in message ... I have my invoices in Excel. I want to be able to type in the name of the client, and have it automatically fill in the address. Any help out there? Thanks. |
|
#3
|
|||
|
|||
|
Take a look at the VLOOKUP function.
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Cbrat" wrote in message ... I have my invoices in Excel. I want to be able to type in the name of the client, and have it automatically fill in the address. Any help out there? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I fill colour in a excel cell from a return from an "IF" test. | Excel Worksheet Functions | |||
| Possible? formula in one cell can fill another cell | Excel Worksheet Functions | |||
| how to create a variable column in cell reference | Excel Worksheet Functions | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
