Lists, Dependecies, vlookup help

I have used Excel for years but never tried the power functions.

I have a cover sheet that I am trying to develop.

I have self learnt the basic of lists, vlookup and indirect.. But now I am lost but wanting more.

The cover sheet has several fields. For ease of explantion I will call field a,b,c and d.
The table I have is made up with 4 columns a,b,c,d

Field A is the main manual enter field but is validated against a list behind.
Once it is filled it adds data to field b. BUT column a can have multiple entries of the same value (it is a property ID) and in column C the Tenant varies due to the history of the property. like this

COLUMN A	COLUMN B	COLUMN C	COLUMN D
1	Address 1	Tenant A
1	Address 1	Tenant B
2	Address 2	Tenant C
2	Address 2	Tenant D
3	Address 3	Tenant E
3	Address 3	Tenant F

So I am now stuck because I cannot get it show column C as a list.

I am also looking at how to Have sections have cascading dependencies.

Section A is from a list (these are departments), I then have Section B populate from the dependencies of Section A (these are limited based on department and the topics available to that department. I am using named boxes for this.
I then need to have Section 3 populate of Sections A and B to have a drop down list of document types for the topics available.

Also not sure if there is to clear all the data added for the next cover sheet to be completed.

So I am sure these are possible just have no idea how or where to complete my project...

I look forward to any help and it is really appreciated.
Thanks inadvance
WeezyPenguin

and add an excel file, without confidential information.

Please also add the desired result in your sheet.

Sorry did not know what to head it. Also uploading file now

I have added file also

Also edited description at the start
I think once you see the sheet you will get it

Thanks In advance

2 things,

Where can forummembers see the result in your sheet.

I noticed you work with merged cells.

Don't work with merged cels, you get in trouble with it sooner or later.

add the desired result in your file and show us the related cells (e.g. with an color).

I don't understand the question, so maybe anothe forummember can help you out.

off course i looked at the file, but i don't understand it.

a smaller example could also be usefull.

in short if you select PropertyID how can I get the client name to present as a list so the user can select the desired client.
Look at the table at the front of the post. It shows property id (column A) repeats over several rows, but the client name always differs.
So if I select Property ID = 1 (this has 2 options) so in the client ID field it gives me both selections in a drop list do I can pick the correct one. So I could pick either Tenant A or Tenant B


I have tried to create a sample but it does not show what you need to see

Also you mentioned merged cells, could you explain the issue I may get when using them and what would be a better option

I do appreciate you help and time with this

Weezy

You get problems with cell references if you use merged cells.