Submit your Microsoft Lists ideas to the Microsoft Feedback portal

Is it possible with MS Lists to search within another MS List, based on an input in first list?

We have 2 Lists,

List A, List B.

List A has following data:

column 1:

(drop down selection box, consisting of searchexample1 , searchexample2, searchexample3)

column 2:

resulting value: (to be picked up from List B - see below)

List B has following data:

column1:                 column2:

searchexample1      bogus1.1

searchexample2      bogus2.1

searchexample2      bogus2.2

searchexample2      bogus2.3

searchexample3      bogus3

Example 1:

List A:  user selects "searchexample2" from a dropdown (selection) list

User gets a presented a dropdown selection, consisting of bogus2.1, bogus 2.2, bogus 2.3

Example 2:

List A, user selects "searchexample3"

User gets presented selection consisting only of bogus3

Appreciate any help/feedback

thanks,