Nested IF or Some Other Function ?

[Anonymous]

I need to create a chart (straight table) from a dataset similar to attached Excel. Requirement is to pick Client Name (and rest of the row):

if        Area Name = Research and Type = Region and Rank value exists then pick that row

else if Area Name = Overall     and Type = Region and Rank value exists then pick that row 

esle if Area Name = Overall     and Type = Overll and Rank vlaue exists then puick that row

if none of the above matches, move to next Client.

Only one row should be picked for any Client.

Any suggestions ?