Looking up Max Values and Corresponding References

[Ravi Rajendran]

Hello All, Hope you all had a great day!

I am looking for help with ways i can simplify the process of looking up values (which i have managed some how but also need to lookup the corresponding references.

It is little hard to explain here without the scenarios but if you look in the attachment. it will be lot clearer. many thanks

Ravi

 

[Villalobos]

Hi Ravi,

Is it help for you?

 

[Ravi Rajendran]

Thank you Mate!

I will give this a go and let you know if this works! Many thanks again.

 

[Ravi Rajendran]

This was Perfect! Thank you Again for your assistance. Cheers.

 

[Villalobos]

Thank you the feedback Ravi, glad I could help.