ExcelBanter - get text from another worksheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - get text from another worksheet (https://www.excelbanter.com/excel-worksheet-functions/82927-get-text-another-worksheet.html)

Nick

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?

John Lyons

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?

All times are GMT +1. The time now is 12:31 PM.