I'm trying to create a formula that will search a column and if a match is
found return the data in the cell next to my original number. In this
instance, I have a column of numbers that represents a company. On another
worksheet, I have a column of all of the company numbers and the next column
is the company name. I want to search the list of company numbers and return
the company name in the other worksheet.
--
Ron

Ron,

This assumes the table you want to look upo is on sheet to and your company
numbers are in A1 down on another sheet. Put this in B1 and drag down as
required.

=VLOOKUP(A1,Sheet2!$A$1:$B$46,2,FALSE)

Mike

"Ron" wrote:

I'm trying to create a formula that will search a column and if a match is
found return the data in the cell next to my original number. In this
instance, I have a column of numbers that represents a company. On another
worksheet, I have a column of all of the company numbers and the next column
is the company name. I want to search the list of company numbers and return
the company name in the other worksheet.
--
Ron

See help on VLOOKUP


Gord Dibben MS Excel MVP

On Wed, 3 Dec 2008 07:16:08 -0800, Ron
wrote:

I'm trying to create a formula that will search a column and if a match is
found return the data in the cell next to my original number. In this
instance, I have a column of numbers that represents a company. On another
worksheet, I have a column of all of the company numbers and the next column
is the company name. I want to search the list of company numbers and return
the company name in the other worksheet.