Should I use Volokup or Index/max for this problem?

[M_Burgess]

I am trying to find a formula to use for a spreadsheet I am building. I have two columns, A has names, B has numbers. I want to find the max number in column B and return the value in column A from the same row. I know this is way easier than I am making it but it has been a while since Ive used excel and cant seem to jog my memory ths morning.
Also there will most likely be more than row that has the same max value, is there any way to get it to return more than one name. For instance Sam and Sal both have the same number in column B. Can it say Sam,Sal in the cell for the returned value?



Thanks for your help.

[JosephP]

You need INDEX, MATCH and MAX

=INDEX(A1:A100,match(max(B1:B100),B1:B100,0))

[darknation144]

Please change your title to something like finding max number as per forum rules.

Are there duplicate values in B?

[darknation144]

That formula JosephP will only return the first max value that is found. M_Burgess do you need to return multiple names if they have the highest number?

[Dennis7849]

See the sample attached.

Click on the first value in column B(cell B2).
From the toolbars, click on the Sort Descending(Z A down arrow image on it).

[M_Burgess]

yes i would like to return multiple names if they have the same value.

[JosephP]

I didn't see the edited post! if you need more than one name returned you're gonna need some code, or you'll have to use more than one cell for the answers.

[M_Burgess]

I have the formula working so it returns the first name, is there an easy way to have it return multiple names?

[JosephP]

If you are okay with code you can have all matches returned to one cell. If not but maybe you know there will never be more than 3 matches, you could use formulas in three cells to return each match?