indexing - find greater than/equal value in a column excel -
I am using INDEX and MATCH functions in Excel 2011 to know the precise date when stock value (contained in B2
= Index (A6: A24, Match (B2, IPL) D6: D 24,0))
In the example given below, Found: 9/5/14 12:45. And that's right because it actually matches that value.
But if I try the same formula that matches the value of 1.40 9 64, then I got the NA value. And this is wrong because I should be bigger than 19/5/14 12:45 as it should be 1.40 9 64 1.40 9 63 and it means that the value has been done.
How can I create a form that matches matches
thanks
In your test excel file, the D10 value is 1.40963, hence the N / A error occurs
Try it -
= INDEX (A5: A29, MATCH (B1, D5: D29,1))
Comments
Post a Comment