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