I have something bad validation, When there is data in column 2 of the input sheet, before performing VLOOKUP. However, when the data is checked in column 3 of the master sheet, the data is not found. In this case, an error message should appear stating “no data” and the bot will stop. If the data exists, it can proceed to the VLOOKUP process. I have already created the steps. However, I’m stuck. Is the validation already correct?
Main.xaml (20.4 KB)
excel testing.xlsx (11.1 KB)
I am trying to access this file but this is protected (what is password?).
Regards,
Rajesh Rane