Thread
:
Creating Text based chart and formula help?
View Single Post
#
2
Posted to microsoft.public.excel.misc
galimi
external usenet poster
Posts: 210
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 With Quote
galimi
View Public Profile
Find all posts by galimi