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 |