Hi all,
Following is the formula which is working:
=IF(ISERROR(INDEX(AllIDM!$A$1:AllIDM!$C$500,SMALL( IF(AllIDM!$A$1:AllIDM!$A$500="Branch",ROW(AllIDM!$ A$1:AllIDM!$A$500)),ROW(Sheet3!1:1)),3)),"",INDEX( AllIDM!$A$1:AllIDM!$C$500,SMALL(IF(AllIDM!$A$1:All IDM!$A$500="Branch",ROW(AllIDM!$A$1:AllIDM!$A$500) ),ROW(Sheet3!1:1)),3))
AllIDM is the main worksheet having complete data, Branch is test
condition.
Thanks
GSNIVAS
--
gsnivas
------------------------------------------------------------------------
gsnivas's Profile:
http://www.excelforum.com/member.php...o&userid=25860
View this thread:
http://www.excelforum.com/showthread...hreadid=392445