Hi everyone,

I'm having a nightmare trying to get a spreadsheet to do what I would like it to do.

I'm not an excel expert at all but feel I can learn about the formulas I may need.

So here goes... I've got the following sets of data (at the moment in different sheets which I hate)

Site name, Address, Email, Telephone

And then each site has a varying number of organisations "attached" to it. These organisations collect items from the "site" on a rotational basis each week.

On a seperate spreadsheet I have the organisation name, address, email, telephone.

I would really like to be able to select the "site name" and then have it display the organisations that are tied to it. I then want to be able to select the organisation... and it shows me all the information for them.

Is this too complicated? Am I living in dream world? Or perhaps I should use an access database... I don't know help would be greatly appreciated.