title: Excel - Index Match with Large function: Show duplicate values?
body: <p>I am using the following array forumla:</p>
  
  <pre><code>=INDEX('Opp Data'!$H:$H,MATCH(1,('Opp Data'!$G$1:$G$1000=$A$10)*('Opp Data'!$K$1:$K$1000=LARGE(IF('Opp Data'!$G$1:$G$1000=$A$10,'Opp Data'!$K$1:$K$1000),6)),0))
  </code></pre>
  
  <p>The formula is designed to look up my Opp Data sheet which is laid out like the below:</p>
  
  <pre><code>Column H         Column G          Column K
  Client A         Aerospace         £200
  Client B         Rail              £150
  Client C         Aerospace         £100
  </code></pre>
  
  <p>The formula should check which clients have the highest spend and using Large function, on each row i can set my 1st, 2nd and 3rd largest values etc.</p>
  
  <p>I am also checking my cell A10 which has the word 'Aerospace' in it.
  The formula should only return those client names that have aerospace corresponding to them in column g.</p>
  
  <p>My end result should look like this.</p>
  
  <pre><code>Client A
  Client C
  </code></pre>
  
  <p>This works fine, however if we had two clients with the same value in column k like so:</p>
  
  <pre><code>Column H         Column G          Column K
  Client A         Aerospace         £200
  Client B         Rail              £150
  Client C         Aerospace         £100
  Client D         Aerospace         £100
  </code></pre>
  
  <p>Then client D is not listed and my formula reproduces client c twice.</p>
  
  <p>Please can someone show me how i can get duplicate values (NOT duplicate client names!) to show?</p>
  
  <p>Am i doing something wrong? Thanks in advance</p>