I am trying to match a project code name in one column with a condition field in another column and then return the smallest value, which is a date.
So if the project is C4 and the condition is "execute" there may be four or more records that meet this, but I want to return the first instance of this occurring by minimizing the date column.
What I have done so far that finds the first record, but not the smallest is :
[code]=INDEX(A2:C9,MATCH(A14&B14,B2:B9&C2:C9,0),1)
I think I need a MIN function somewhere, but haven't been able to get it to work.
Help is appreciated...
Bookmarks