Quote:
Originally Posted by DaFace
=INDEX(A7:B37,MATCH(1000000,B7:B37),1)
That work?
|
Nope, returned 30-jan
I havent been using the index feature in class but have briefly touched on vlookup so it is a safe bet to say the first thought was the right one.
reading my textbook tho...
use vlookup to search for exact matches or for the nearest value that is less than or equal to the search value.
which is why it returns the 27th. its looking for the lowest value under 1m.