Lookup for more than one result
 

I want to use look up or match function to extract the data from a given
date, but there is more then one of the same date? How the lookup or match
function will give me the "second" or "third" matching line.

Lookup for more than one result
 

I have provided an example of this at
http://www.HelpExcel.com/examples/positionLookup.xls
--
http://HelpExcel.com




"noyau" wrote:


I want to use look up or match function to extract the data from a given
date, but there is more then one of the same date? How the lookup or match
function will give me the "second" or "third" matching line.