Hello Jim,

I will giive a go asap and keep you informed
Thank you
Regards
JY

"Jim Cone" wrote in message
...

With help from Bob Phillips...
If your data is in B20:F25 then
=MAX(IF(B21:B25=125,E21:E25)) ... entered as an array formula.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Jean-Yves"
wrote in message
Hello,
I would like to find the equivalent XL formula for this situation:

Payrol - Name - Startdate - EndDate - Function
123 Bob 01/01/2008 31/12/2008 Coach
124 Greg 01/01/2007 31/12/2007 Coach
124 Greg 01/01/2007 31/12/2007 Coach
125 Henry 01/01/2007 31/12/2007 Coach
125 Henry 01/01/2008 31/12/2008 Supervisor

The lookup should be one in the same workbook.
SELECT Max(EndDate) FROM [Workseets(1)!DataRange] WHERE Payroll = '125'
It should return "31/12/2008" for Henry (payroll:125)
Or eventually, can I use SQL to query this workbook directly. I know how
to
do it in ADO to a closed workbook,
but i never used it for a kind of lookup in the actual workbook.
Thank you in advance
Jean-Yves Tfelt