Hi,

Please read up on the VLOOKUP() & INDEX(), MATCH() functions in the Help
menu

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Andy Mc" wrote in message
...
Hi guys,

Would anyone be able to give a little advise?

I am trying to make a database in Excel, due to License restrictions (and
cost), Excel is the only program we have a site license for.

The database needs to be able to hold regions of data, which will show
contact details for each region. In each region it would show around 20
Technicians, 2 Supervisors, 1 Manager, a Field manager, and finally the
Head of Department. I would also like to make it possible that they just
enter the Region Code or Tech ID and it bring up the region they work in.

I know it sounds like a tall order but if someone could give me some
advise as to which functions would be the best to use that would be a
great help. Or if you already have something like this give me a head
start. But please do not pass any actual data. I do not want people
getting into trouble (Data Protection Act).

I am also trying to learn more about Excel so I can eventually be able to
create something more complicated easily.

Kindest regards,

Andy Mc