Conditional Max Function

[ronnycool]

Capture.JPG

please have a look at the attached image.

Is there any function that will return the value from column "C" for the max value from column "B"????


Please reply.

[Winon]

Hello ronnycool,

Maybe like this?

Regards

[ronnycool]

thanks a lot...!!!

is there any other function for the same technique????

[martindwilson]

???
=index(c2:c6,match(max(b2:b6),b2:b6,0))

[ronnycool]

thanks a lot...!!!

It worked....!!!!!!!!

[Winon]

You are welcome.

You may also Click on the star "*", bottom left, to show some appreciation.

is there any other function for the same technique????

It would depend on exactly what you want to do.

The solution I gave you, was based on the image you have posted, and I don't understand why you would now want to consider a different approach.

If you have other questions regarding different issues, then you should mark this thread as "Solved", and start any other new thread.

Regards

[reimar_rem]

=index(match) is same sa vlookup.

but vlookup is easier.

[martindwilson]

that's a matter of opinion,i hardly ever use vlookup unless an op asks for help with it!

[Winon]

Hello reimar_rem,

=index(match) is same sa vlookup.

but vlookup is easier.

Yes, you are correct, but sometimes you may find Index,Match better than Vlookup.

Regards

[Winon]

@ martindwilson,

Hi Martin,

I agree with you. Also thank you for helping out here as well!

Best Regards

[reimar_rem]

Hi Guru,

Agree, sometimes index match is better.

[reimar_rem]

Hi Guru,

Agree, index match is sometimes better.

[newdoverman]

INDEX MATCH combination can lookup left or right with a vertical arrangement of data or with horizontal data, UP or DOWN.

VLOOKUP can only return from left to right for vertical data and HLOOKUP from UP to down for horizontal data.