Valid if THAT DOES NOT DIE DROPDOWN HELP!

Hello! I floor your help, I have a table (A) where the information is entered and another table (B) where there is personal data ID, NAME I want to use the VALID IF function in the table (B) to call the ID column of the table (A) but that is not dropdown since it will be the ID of the employees, and I don’t want anyone to be able to use the ID to record the information, what I want to achieve is that when the ID does not match, I only show the error

1 Like

Hi,
Try using this.

IF( IN([_THIS],TableA[ID]) , TRUE, FALSE)

3 Likes

WOW FRIEND @Yogesh_laddha ! Thank you, you saved me many hours of work! Thank you so much

2 Likes