I have two different excel workbooks,which are attached here.I want to match column ( patient_symptom of workbook patient) with column of second sheet(patient_symtomps of workbook doctors ) and want display the doctors name when match found .can anyone please help me asap.patient.xlsx (8.1 KB)
doctors.xlsx (8.1 KB)
@Aarjuna try below workflow.
matc-----.xaml (9.9 KB)
thank you so much Manju…but if want to display patient_name along with doctor name,then what will be the code in message box?
@Aarjuna check below file, i have made one change now.
matc-----.xaml (9.9 KB)