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

Popular posts from this blog

apache - 504 Gateway Time-out The server didn't respond in time. How to fix it? -

c# - .net WebSocket: CloseOutputAsync vs CloseAsync -

c++ - How to properly scale qgroupbox title with stylesheet for high resolution display? -