Hi,

I have a list of Team Leaders, Agents, and the agents conversion rate.

The conversion rate is updated daily from telephony reports, and I manually sort it into conversion order each day before sending it round.

What I want to do is find the highest converter for each team.

So:

Column A ('TeamLeader' range) has the Team leaders in, column B has the agent name ('Agent' range), and column F has the agents conversion rate ('conversion' range).

I think I'm on the right track with this formula:

=(MAX(IF(TeamLeader="Bonnie",Conversion))

But this only displays the figure in the Conversion rate, how to I get it to 'step back' 4 column's and show the agents name?

I tried this:

=VLOOKUP(MAX(IF(TeamLeader="Bonnie",Conversion)),A5:F60,-4,FALSE)

but that returns #NA - is this because I'm asking the VLOOKUP to look 'backwards' 4 columns?

Thankyou! Hope this made sense!

I have a list of Team Leaders, Agents, and the agents conversion rate.

The conversion rate is updated daily from telephony reports, and I manually sort it into conversion order each day before sending it round.

What I want to do is find the highest converter for each team.

So:

Column A ('TeamLeader' range) has the Team leaders in, column B has the agent name ('Agent' range), and column F has the agents conversion rate ('conversion' range).

I think I'm on the right track with this formula:

=(MAX(IF(TeamLeader="Bonnie",Conversion))

But this only displays the figure in the Conversion rate, how to I get it to 'step back' 4 column's and show the agents name?

I tried this:

=VLOOKUP(MAX(IF(TeamLeader="Bonnie",Conversion)),A5:F60,-4,FALSE)

but that returns #NA - is this because I'm asking the VLOOKUP to look 'backwards' 4 columns?

Thankyou! Hope this made sense!

Last edited: