Hello All,
I am trying to build a formula to capture the value in the cells based on the first occurring number from a range in a particular column
capture122345453.JPG
In the current example looking for a formula which can search for the first occurring number in the range(1,2) in column E and return the corrsponding values in the other 2 columns test1 and test 2.
The range can be dynamic. I tried Index, match etc but could not build a working formula.
Thank You
Bookmarks