| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Which function wd I use to set up a ref to a list of possible
YES!! You are both fantastic...thanks so much.
"DonCam65" wrote: Don't forget to sort column J in ascending order or it will not work -- Don C "T. Valko" wrote: 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 |
| 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
