*
*
*
*
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 wrote:
> 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$
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
