| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
get text from another worksheet
I am trying to get text data from one worksheet to copy to another worksheet.
For example, in column A in wkst1, I have a list of several customer numbers. In column A in wksht 2, I have every customer number and their respective names are in column B. I would like to have a formula in column B in wksht 1 to find the customer name from wksht 2. Is this possible? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
get text from another worksheet
Have you tried using VLOOKUP
"Nick" wrote: I am trying to get text data from one worksheet to copy to another worksheet. For example, in column A in wkst1, I have a list of several customer numbers. In column A in wksht 2, I have every customer number and their respective names are in column B. I would like to have a formula in column B in wksht 1 to find the customer name from wksht 2. Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need to use a number in one worksheet to match text in another | Excel Worksheet Functions | |||
| importing multiple text files into the same worksheet | Excel Discussion (Misc queries) | |||
| enable a scrolling cell with lengthy text within a worksheet? | Excel Discussion (Misc queries) | |||
| I have had trouble with textbox text to worksheet | Excel Discussion (Misc queries) | |||
| Bring all text from "Text" worksheet | Excel Discussion (Misc queries) | |||
Linear Mode
