| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| want to use list, while using if function? | Excel Worksheet Functions | |||
| LIST function | Excel Worksheet Functions | |||
| List Function | Excel Worksheet Functions | |||
| If function using a list of criteria | Excel Discussion (Misc queries) | |||
| Can I use a List in a IF Function? | Excel Worksheet Functions | |||
Threaded Mode
