View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Lyons
 
Posts: n/a
Default 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?