Conditional Show corresponding to field value in related table

[#1]

On a list box I only want to show the Field values that have another field value associated to them.

Table A			Table B
ID	Name		Name	Input
1	A		A	Yes
2	B		B	No
3	C		C
4	D		D

For Example from the above tables I create a list box in a Sheet with ID and Name, I only want it to display those IDs that have a value in Input field in table B

[#2 · Accepted solution]

write an expression in the list box instead of column . Assuming that Table A and B are associated with Name column.

if(len(input)>0, ID)

[afurtado]

Hi

like Eddie Morah but other expression

=if(Input <> '',ID)

Best,

Alessandro Furtado

[afurtado]

but thinking better it depends about your data.  Like Eddie Morah will works everytime  (using len).....

Alessandro Furtado

[#5]

Thanks guys was very helpful