Lookup Value Base on Rank Date

[Sophanith]

Dear Excel Masters,

We would like to look up the data base on rank date and with criteria name "A" but we really difficult to find the solution so we really need your help. For more detail please find attached file.

Regards,

Sophanith

 

[Nebu]

Hi:
Find the attached.

Note: Array formula.

Thanks

 

[Sophanith]

Dear Nebu,

That is the previous file. can you get the attached file to working on because the result a bit different from your file that you have responded.

Thanks

Sophanith

 

[Nebu]

Hi:

Find the attached.

Note: Array formula.

Thanks