Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating Text based chart and formula help?
Hi there, I'm trying to create a table that can be applied to a column in
excel 2007. This is a spreadsheet that will attach names of salespeople to an industry type en masse. So basically I would need to set some guidelines linking people with industry types, for instance link Steel to John Doe and Iron to Jane Smith, etc. These guidelines would then be inserted in a column next to the industry type, so when I drag down the formula the salespeople are automatically inserted next to the relevant industry types. A little complicated? probably, but any help would be appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating Text based chart and formula help?
Il Duce,
Sounds like you just need a vlookup. -- http://www.ExcelHelp.us 888-MY-ETHER ext. 01781474 "Il Duce" wrote: Hi there, I'm trying to create a table that can be applied to a column in excel 2007. This is a spreadsheet that will attach names of salespeople to an industry type en masse. So basically I would need to set some guidelines linking people with industry types, for instance link Steel to John Doe and Iron to Jane Smith, etc. These guidelines would then be inserted in a column next to the industry type, so when I drag down the formula the salespeople are automatically inserted next to the relevant industry types. A little complicated? probably, but any help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Chart based on Values from One Column | Charts and Charting in Excel | |||
Creating a chart of text data | Excel Discussion (Misc queries) | |||
Creating a chart with text not numbers | Charts and Charting in Excel | |||
suggestions on creating a text value based on a date range | Setting up and Configuration of Excel | |||
need help creating formula based on cell value | Excel Discussion (Misc queries) |