Adding error message to the pulldata when not matched

Hi Kal, how we can add validation to pulldata function? Ex: the name or the number is not in the list to pull data from the csv file , i want to give an error message like "ID/Name is invalid "

@dimesh, maybe this post discussed previously should help you solve your issue:

@Kal_Lam Thanks for your information. It helps.

@Kal_Lam i need to check with the text field , then the condition should be check with ID number listed in the CSV file and pull the data . if the ID number is not exists in the list then should gibe the error message
ID number Format : 867654376V, 7898767654V

I can not go with < or > = condition for this. can you provide some guidance to do it.

@Kal_Lam , in case we enter an wrong patientid then how we can show an error message?
If the patientid not in the csv file, how to check in “calculation” column?

I need calculation condition similar to below one, how to compare text field with the csv file text field:

if(${code} <=3, pulldata(‘Codes’,‘Book’,‘Code’,${code}),if(${code} >3, ‘Invalid Book Code Entered’, ‘’))