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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top