How can i join these two formulas?

[Frustrated]

I have two working formulas and i need to put them both together in one
string. Can anyone please help. i want to display the name of the top seller.
The first formula was the orginal and now i have more employees and the 2nd
formula does the same thing. All cells referrals need to stay the same.

Formula 1: =INDEX(A10:A14,MATCH(MAX(H10:H14),H10:H14,0))
Formula 2: =INDEX(P1016,MATCH(MAX(V10:V16),V10:V16,0))

 

[Jacob Skaria]

Try the below version

=IF(ISNA(MATCH(MAX(H10:H14,V10:V16),H10:H14,0)),INDEX(P1016,
MATCH(MAX(V10:V16),V10:V16,0)),INDEX(A10:A14,
MATCH(MAX(H10:H14),H10:H14,0)))

 

[T. Valko]

You can't combine them because they reference different ranges.

Either consolidate the data to a single contiguous range or...

A possibility is to download and install the free add-in Morefunc.xll from

http://xcell05.free.fr/morefunc/english/index.htm

Alternate download site:

http://www.download.com/Morefunc/3000-2077_4-10423159.html

It has a function that will allow you to combine those different ranges into
a single range.

=INDEX(ARRAY.JOIN(A10:A14,P1016),MATCH(MAX(ARRAY.JOIN(H10:H14,V10:V16)),ARRAY.JOIN(H10:H14,V10:V16),0))

 

[p45cal]

i have two working formulas and i need to put them both together in one
string. Can anyone please help. I want to display the name of the to
seller.
The first formula was the orginal and now i have more employees and th
2nd
formula does the same thing. All cells referrals need to stay th
same.

Formula 1: =index(a10:a14,match(max(h10:h14),h10:h14,0))
formula 2: =index(p1016,match(max(v10:v16),v10:v16,0))

=index(a10:a14,match(max(h10:h14),h10:h14,0)) & ", "
index(p1016,match(max(v10:v16),v10:v16,0))

 

[T. Valko]

Improvement...

We can eliminate the ARRAY call within MAX:

=INDEX(ARRAY.JOIN(A10:A14,P1016),MATCH(MAX(H10:H14,V10:V16),ARRAY.JOIN(H10:H14,V10:V16),0))

 

[minyeh]

I have two working formulas and i need to put them both together in one
string. Can anyone please help. i want to display the name of the top seller.
The first formula was the orginal and now i have more employees and the 2nd
formula does the same thing. All cells referrals need to stay the same.

Formula 1: =INDEX(A10:A14,MATCH(MAX(H10:H14),H10:H14,0))
Formula 2: =INDEX(P1016,MATCH(MAX(V10:V16),V10:V16,0))

try this,
=IF(MAX(H10:H14)>MAX(V10:V16),INDEX(A10:A14,MATCH(MAX
(H10:H14),H10:H14,0)),INDEX(P1016,MATCH(MAX(V10:V16),V10:V16,0)))