Returning a value from the cell next to my match
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 |
Returning a value from the cell next to my match
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 |
Returning a value from the cell next to my match
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. |
All times are GMT +1. The time now is 11:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com