VLOOKUP & MIN date

[LEXCERM]

Hi,

I would like a formula to:-

a) Find the MIN value in ColB which corresponds to value "A" in ColA (which will be 01-Feb)
b) Return the corresponding value in ColC (which will be 15-Feb)

Bearing in mind I have hundreds of rows with similar data but different values in ColA.

ColA	ColB	ColC
A	03-Feb​	01-Feb​
A	05-Feb​	08-Feb​
A	01-Feb​	15-Feb​

Also, if ColA was the last column, can this be achieved by using INDEX/MATCH etc?

Many thanks in advance.

 

[LEXCERM]

I shall try this soon and get back to you, but thank you so much for the help. Much appreciated.

@Joe4 Tested and verified that it works a treat! Many many thanks.

 

[Joe4]

@Joe4 Tested and verified that it works a treat! Many many thanks.

You are welcome.
Glad I was able to help!

 

[Peter_SSs]

Another option could be

=INDEX(SORT(FILTER(A$2:C$25522,A$2:A$25522=A4370),2),1,3)