I need help with a formula for Microsoft Excel, please help?

Question

I have two columns with data, column A and column B. Column A has titles of movies, and column B has prices of the corresponding movies. I have a cell which asks for the "title of highest price movie," I am trying to come up with a formula that does not return the max price, but returns the actual name of the movie in text that has the max price. Can anyone help me out? It's greatly appreciated.

Answer 1

Don't know if that's possible. You could just sort by the price column.

Answer 2

To return the movie title in a single cell instead of sorting, you can use VLOOKUP:

=VLOOKUP(MAX(A2:A10),A2:B10,2)

The columns in the sample above correspond to the following:
Column A = Price
Column B = Title

So, the function looks for the maximum value in the Price column (1st parameter) and returns the corresponding value in the second column of the range identified in the second parameter. The final parameter tells the function whether to return the 1st or 2nd column in the range (or 3rd, 4th, etc. if you have more than 2 columns).

Answer 3

This is very easy task if you use price coloumn perior to Movie Name. if you able to do that you can use vlookup function in following manner.
VLOOKUP(max(A1:200),A1:B:200
,2,False)
Be Sure to using Price as coloumn as column A.
Best of luck

Answer 4

sort it by the price column.

Answer 5

tats very simple, to sort datas (even with multiple rows and multiple colounms), go to data and click on sort. but before that select the column that u want to sort............ for more information look in to the following website
http://www.seattleu.edu/it/training/Manuals/exl004.pdf

Answer 6

check this website:-