Which function wd I use to set up a ref to a list of possible name

[Guest]

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

 

[T. Valko]

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

 

[Guest]

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

 

[Peo Sjoblom]

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)

 

[Guest]

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

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