Returning a value from the cell next to my match

[Ron]

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.

 

[Mike H]

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

 

[Gord Dibben]

See help on VLOOKUP


Gord Dibben MS Excel MVP