Validate when modifying the Cell row

[blader1989]

Dear all,

I have a file with lot of ID of doctors and following below is some example from my file.

ID	FULL NAME	HCO_ID	HCO_NAME	HCO_Address	HCO_Address ID
0012j00000BIaNAAX	James Black	0012j00000BRBMQAA5	BV 103 261 Phùng Hưng, Phúc La	261 Phùng Hưng, Phúc La	a012j000002t6NiAAI
0012j00000BTGh0AAH	Metal Gear	0012j00000BRNMQAA5	BV 109	214 Tran Hung Dao	a012j000002t6MiAAI

Each row is bind together (ID -> FULL NAME, HCO_ID -> HCO_NAME and HCO_Address ID -> HCO_Address) so is there any way that we can build the validation that if they input or copy wrong ID, it will show error.

For example above, if I input wrong ID in the ID column which same row with Metal Gear -> it will say "this ID is not correct" similar with HCO_ID and Address ID. Because in every quarter we will have the modification for our territory so I want to build this validation to prevent mistake in editing this file.

Thank you so much.

 

[Skovgaard]

Hi,

What is a wrong ID?
Do you have a list with correct ID's or is it just a check, if the ID is already in the list?

/Skovgaard

 

[blader1989]

Hi,

What is a wrong ID?
Do you have a list with correct ID's or is it just a check, if the ID is already in the list?

/Skovgaard

Hi Skovgaard,

Yes we have the correct list for backup.

Like this example:

ID	FULL NAME	HCO_ID	HCO_NAME	HCO_Address	HCO_Address ID
0012j00000BIaNAAX	James Black	0012j00000BRBMQAA5	BV 103 261 Phùng Hưng, Phúc La	261 Phùng Hưng, Phúc La	a012j000002t6NiAAI
0012j00000BTGh0AAH	Metal Gear	0012j00000BRNMQAA5

Suppose the ID: 0012j00000BIaNAAX is belong to James Black, then suddenly one of my teammate made mistake when copying or input the wrong ID like 0012j00000Badsaw2 --> popup will appear "this ID is not correct or you are copying wrong ID".

Maybe we will have the last option is double check with this file and the correct list file to validate by using the IF function but we hope there will be a better solution. Thank you.

 

[Skovgaard]

I'm still not sure what to check on...

1. When ID is pasted, do you want to check if this ID is in another list?
2. If you have a list of all doctors, another "check" could be a lookup on name and addresses...?

/Skovgaard