I'll try to make this brief.

Column A has A B C D E F G

Column B has A10, B20, C30 etc

Column C Has A1010 B1010 C1010 etc

Column F has A1014, B1019 etc.

These need to be pickable from a drop down menu. Is it possible to execute a validation that makes sure that if Column F has B1019, that columns A-C are all correctly pointing to the B entry (B, B10, B1010)?