Help with List validation settings

[LearnerD]

Hi

I'm looking to achieve the following ! I don't know whether to use vlookup, offset, indirect or a combination of 2 have looked and looked and looked !! and can't find a solution similar to what I'm trying to achieve I did see one post similar but it didn't solve it for me ok here's what I need to do.

Table1 contains the following ( FYI all columns in each of the tables have defined name ranges)

Column1	Column2
Process 1	ABC
Process 1	DEF
Process 1	GHI
Process 2	JKL
Process 2	MNO

<tbody>
</tbody>

Table 2

Column Name1	Column Name2
Process 1	so here I want a drop down which shows only the values in Column2 from Table 1 that match Column Name1 so in this example it would be a drop down with ABC DEF GHI I wouldn't see JKL or MNO
Process 2	In my drop down here I would see JKL MNO

<tbody>
</tbody>

I hope you can follow and I really hope there a solution

Many thanks in advance

 

[SpillerBD]

see
https://www.mrexcel.com/forum/excel-questions/1045004-conditional-validation-list.html

 

[LearnerD]

Thank you I'll check that out.