Lookup Function

[andibevan]

Hi All,

I have a large table of data that contains the following information:-

Column 1 - File Name
Column 2 - Version Number
Column 3 - Date

Essentially it is a list of what documents were saved when and wha
version number they were.

What formula could I use to find the maximum version number that i
between 2 specified dates.

I.e. the highest version of document1.doc that was saved between 1/1/0
and 1/2/04.

Any ideas?

Thanks

And

 

[Frank Kabel]

Hi
try thwe following array formula(entered with cTRL+SHIFT+ENTER)
=MAX(IF((A1:A100="document1.doc")*(C1:C100>=DATE(2004,1,1))*(C1:C100<DATE(2004,2,1)),B1:B100))