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)

[TABLE="width: 500"]
<tbody>[TR]
[TD]Column1[/TD]
[TD]Column2[/TD]
[/TR]
[TR]
[TD]Process 1
[/TD]
[TD]ABC[/TD]
[/TR]
[TR]
[TD]Process 1[/TD]
[TD]DEF[/TD]
[/TR]
[TR]
[TD]Process 1[/TD]
[TD]GHI[/TD]
[/TR]
[TR]
[TD]Process 2[/TD]
[TD]JKL[/TD]
[/TR]
[TR]
[TD]Process 2[/TD]
[TD]MNO[/TD]
[/TR]
</tbody>[/TABLE]

Table 2
[TABLE="width: 500"]
<tbody>[TR]
[TD]Column Name1[/TD]
[TD]Column Name2[/TD]
[/TR]
[TR]
[TD]Process 1[/TD]
[TD]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[/TD]
[/TR]
[TR]
[TD]Process 2[/TD]
[TD]In my drop down here I would see
JKL
MNO[/TD]
[/TR]
</tbody>[/TABLE]

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.