LookUp

[tag]

Say I have data like this
A B
Rpm Feed
1000 .005
5000 .003
2500 .002

and I use the formula:
=large(A1:A3,1) to find the largest number in A
how do I multiply the found number by the corresponding number in colum B.

Thanks

 

[J.E. McGimpsey]

one way:

=LARGE(A1:A3,1)*VLOOKUP(LARGE(A1:A3,1),A:B,2,FALSE)