This is chicken feed compared to the complex issues I've read on this site,
but your help would be greatly appreciated. My spreadsheet has 451 sites
listed in a column A. Listed against each site in column B is one of 10
possible contractors codes. I would like Column C to display a text name
associated with each potential contractor code. ie if a4 = 24, then show
Green Bros, if A4 = 32, then show Thomson & Co, etc etc

Create a 2 column table. The left column containing the contractor codes and
the right column containing the corresponding name.

Assume this table is in the range J1:K10

Then use this formula in your column C:

=VLOOKUP(B1,J$1:K$10,2,0)

Biff

"Twishlist" wrote in message
...
This is chicken feed compared to the complex issues I've read on this
site,
but your help would be greatly appreciated. My spreadsheet has 451 sites
listed in a column A. Listed against each site in column B is one of 10
possible contractors codes. I would like Column C to display a text name
associated with each potential contractor code. ie if a4 = 24, then show
Green Bros, if A4 = 32, then show Thomson & Co, etc etc

Don't forget to sort column J in ascending order or it will not work
--
Don C


"T. Valko" wrote:

Create a 2 column table. The left column containing the contractor codes and
the right column containing the corresponding name.

Assume this table is in the range J1:K10

Then use this formula in your column C:

=VLOOKUP(B1,J$1:K$10,2,0)

Biff

"Twishlist" wrote in message
...
This is chicken feed compared to the complex issues I've read on this
site,
but your help would be greatly appreciated. My spreadsheet has 451 sites
listed in a column A. Listed against each site in column B is one of 10
possible contractors codes. I would like Column C to display a text name
associated with each potential contractor code. ie if a4 = 24, then show
Green Bros, if A4 = 32, then show Thomson & Co, etc etc

Only necessary if you don't want an exact match

--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


"DonCam65" wrote in message
...
Don't forget to sort column J in ascending order or it will not work
--
Don C


"T. Valko" wrote:

Create a 2 column table. The left column containing the contractor codes
and
the right column containing the corresponding name.

Assume this table is in the range J1:K10

Then use this formula in your column C:

=VLOOKUP(B1,J$1:K$10,2,0)

Biff

"Twishlist" wrote in message
...
This is chicken feed compared to the complex issues I've read on this
site,
but your help would be greatly appreciated. My spreadsheet has 451
sites
listed in a column A. Listed against each site in column B is one of
10
possible contractors codes. I would like Column C to display a text
name
associated with each potential contractor code. ie if a4 = 24, then
show
Green Bros, if A4 = 32, then show Thomson & Co, etc etc

YES!! You are both fantastic...thanks so much.

"DonCam65" wrote:

Don't forget to sort column J in ascending order or it will not work
--
Don C


"T. Valko" wrote:

Create a 2 column table. The left column containing the contractor codes and
the right column containing the corresponding name.

Assume this table is in the range J1:K10

Then use this formula in your column C:

=VLOOKUP(B1,J$1:K$10,2,0)

Biff

"Twishlist" wrote in message
...
This is chicken feed compared to the complex issues I've read on this
site,
but your help would be greatly appreciated. My spreadsheet has 451 sites
listed in a column A. Listed against each site in column B is one of 10
possible contractors codes. I would like Column C to display a text name
associated with each potential contractor code. ie if a4 = 24, then show
Green Bros, if A4 = 32, then show Thomson & Co, etc etc