I have a datatable and another sheet that contains values for specific tests. I would like the Sheet with the specific tests to search through the datatable for those specific tests and return a -1 if certain conditions are met.
So, If sheets("Data") column c value = 7, and if column L value = "" then if in string in column M = "12.1" then Sheets("Train7").Range("E3").value = "-1"
I would need to search dozens of rows to find dozens of tests. In column C there will only be 1 value (7 in this example). In column L the value will either be a data or empty. In column M there will be some number of values in a string (12.1, 12.2, 12.3). And on the other sheet with the values stored I would like to return "-1" for 12.1 in E3, "-1" for 12.2 in E4, etc.
This picture is the table that the values will be stored.
and this picture is where the data is stored.
So, If sheets("Data") column c value = 7, and if column L value = "" then if in string in column M = "12.1" then Sheets("Train7").Range("E3").value = "-1"
I would need to search dozens of rows to find dozens of tests. In column C there will only be 1 value (7 in this example). In column L the value will either be a data or empty. In column M there will be some number of values in a string (12.1, 12.2, 12.3). And on the other sheet with the values stored I would like to return "-1" for 12.1 in E3, "-1" for 12.2 in E4, etc.
This picture is the table that the values will be stored.
and this picture is where the data is stored.