Quote:
Originally Posted by pr_capone
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.
|
Could you just attach that sheet? It's kind of hard to play with these things without being able to just do it in Excel.