Thread: Which function wd I use to set up a ref to a list of possible name
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default Which function wd I use to set up a ref to a list of possible name
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



Reply With QuoteReply With Quote