Hi Dear Allz,
I am trying to extract values from preceding rows based on a value which is given in next columns.
Like in following example, in cell A2 Cell value is 10 (Highlighted in Green) the corresponding value in cell D2 is 3 (Highlighted in Red) so the value required in Cell E2 is...