Hello Kiran,
In G4 with CTRL+SHIFT+ENTER, rather than just ENTER
=IFERROR(INDEX(D$2:D$498,MATCH(1,IF(ISNA(MATCH(D$2:D$498,G$3:G3,0)),IF($C$2:$C$498=Agent,1)),0)),)
Then copy across down. if you have huge list, this will slow down the
sheet performance.
___
HTH, Haseeb
--
FORUM
*
*
*
*
Hi Noorain/Haseeb,
Perfect answers.
This is what I was looking for...
Thanks...
Kiran
On Thu, Mar 29, 2012 at 9:06 AM, Haseeb A haseeb.avarak...@gmail.comwrote:
Hello Kiran,
In G4 with CTRL+SHIFT+ENTER, rather than just ENTER