"GoExcel.FindRow" not returning error when the values are not matching the excel values

[hamzabuttX6GV8]

Hi,

I use an excel file to pass model parameters. I use the following command to get the exact row:

GoExcel.FindRow("TEST.xlsx", "Sheet1", "BORE", "=", BORE, "FLANGE_OD", "=", FLANGE_DIA, "COOLING_DISK", "=", COOLING_DISK)

 The problem is that when I enter the wrong value of "BORE", it surprisingly doesn't return an error and continues to generate the model. The "BORE" value that I enter is not present in the excel sheet so how does it know which row to go to.

[tyler.warner · Accepted solution]

You can find a related post where @WCrihfield shows some checking for a similar situation here.

[hamzabuttX6GV8]

Thank you! This helped me figure it out.