Hi guys,
I having difficulty to read the appropriate bands from another sheet for a value defined. Ie; if my value for 1L (column H) is 11.21 (in sheet, 'spotless') then my band value should be 20 (as per sheet, 'band'). Similarly, if my value for 18L is 391.17 then my band value should be 720.
The file is attached herewith.
Would appreciate your assistance.
Thanks
Vegobu
Bookmarks