Forum Discussion
Search Array and return column/row data
I want to search the array for a value, have the array evaluate the number and return a value equal to or greater than the searched value and get the row and column information o...
Could you please explain bit more your example. Greater or equal to 26 is 26.2. It gives 80 and 110. Please see attached.
This is a crane capacity chart. In many occasions the weight if a lifted load is known. The "idea" would require inputting the weight then searching multiple capacity charts to assist in selecting a crane.
Thanks