Find specific value and return adjacent cell value

[Andoni]

Dear Forumers,

I am trying to find a formula that will find 1) a specific value and 2) retrun the adjacent cell value.

I have allready managed to find the specfic value which is the MAX value in a range but depending on 2 criterias =MAX(IF(A2:A12=J7;IF(B2:B12=K5;D2:D12)))

Now I need the formula to give me as an output the value of the cell on the right.

I attached you the example.

Thank you!

 

[Ashhu]

Are you looking for this, see attached.

 

[Andoni]

Are you looking for this, see attached.

This solution is great!

However I was wondering if it would be possible to come up to the final result directly without having to find the spectific value (the max) on a separate cell before.

Please find attached the updated xls. template

Thank!!

 

[NARAYANK991]

Hi ,

I am not sure what you want ; see if this is OK.

Narayan

 

[Andoni]

Hi ,

I am not sure what you want ; see if this is OK.

Narayan

Thanks! this is what I was looking for.

 

[Khalid NGO]

Hi ,

I am not sure what you want ; see if this is OK.

Narayan

=INDEX($C$3:$C$13,MATCH(MAX(($A$3:$A$13 = $G2) * ($B$3:$B$13 = H$1) * ($D$3:$D$13)),($A$3:$A$13 = $G2) * ($B$3:$B$13 = H$1) * ($D$3:$D$13),0))

Interesting formula Sir, liked the approach how you incorporate lookup_value and lookup_array. Awesome.