function how to!

[FoSi]

hi all...
i dont know very much of excel... so im a really newbie on this...
but i need to know how do i do this..
so..
i have a table with books and their respectives prices!
like:
booka | 10.00
bookb | 50.00
bookc | 20.00
bookd | 12.00

and what i want to know! what is the function/formula so i can have a
cell with the maximum value/price (=max) but also with another cell
nexto to it with the respective name of book (bookb, in this case)

just like this:

highest price:
bookb | 50.00

how can i do this??
i know its very simple... well... it looks like!

prices:
booka 10
bookb 50
bookc 20
bookd 12

max price:
bookb 50


can someone please helpme?

 

[Peo Sjoblom]

=INDEX(A2:A100,MATCH(MAX(B2:B100),B2:B100,0))

is one way, of course if there are 2 books with same price it will return
the first occurrence

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[Don Guillett]

try this where max finds the largest number and match finds the row and
index shows one to the left.
=INDEX(I1:J100,MATCH(MAX(J:J),J:J,0),1)

 

[FoSi]

hmm...

im getting a error!

what im doing is this:
=indice(A1:A3,corresp(maximo(B1:B3),B1:B3,0),1)
or in english:
=index(A1:A3,match(max(B1:B3),B1:B3,0),1)

im gettin a error on here "A3,corresp" or "A3,match"

in both of the solutions you gave me
what seems to be the problem?

my table:
book | price
A1 | B1
A2 | B2
A3 | B

 

[Peo Sjoblom]

Are you using wrong delimiter? Try

=indice(A1:A3;corresp(maximo(B1:B3);B1:B3;0))




--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[FoSi]

Thank You all... for the help
it works... just well



this last error... was becouse of the commas!

best regard

 

[Don Guillett]

glad we helped.