iLogic Excel Lookup Multiple Possible Finds?

[mthomas]

I"m attempting to use iLogic to populate a parts iProperties based on an excel spreadsheet. In this case there are 4-columns (Height, Width, Thickness, and Part #).

Using the height & width from the model with the "FindRow" function I am able to determine the first instance in the spreadsheet with these values, however what do I do when there are multiple lines with the same height and width but the thicknesses vary?

Since I have the first row that matches the height and width is there some way to interate until the height or width changes?

Thanks

[Anonymous · Accepted solution]

Can you not use your thickness in the lookup ? That would determine the unique row :

i = GoExcel.FindRow("c:\temp\testbook.xls", "Sheet1", "Height", "=", 1800, "Width", "=", 500, "Thickness", "=", 20)

Tom

[mthomas]

Doh!... of course the lookup can do more than 2-columns

Thanks!