Valid if THAT DOES NOT DIE DROPDOWN HELP!

[wsaico]

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

[Marc_Dillon]

How to disallow a selection within drop down without restricting it in ValidIF Questions

My first thought is to try Suggested values to generate the dropdown list (using the same expression you might otherwise use with Valid If), then use Valid If to validate only. The Valid If expression would have to be carefully crafted to return a Yes/No value–not a list–and must not consist solely of an IN() expression. An IN() expression alone will trigger the magic that produces a dropdown menu and would confuse the Suggested values. A common way to avoid the magic is to wrap the IN() expres…

[Yogesh_laddha · Accepted solution]

Hi,
Try using this.

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

[wsaico]

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