Hi, I m using this formula:-
=IFERROR(INDEX('Full-Time Projects 2014-15'!E6:E17,IF('Full-Time Projects 2014-15'!A6:A17="Open",MATCH("Open",'Full-Time Projects 2014-15'!A6:A17,0),"")),"")
And it is returning values as:
Project Name 1
Project Name 2
Note: the space b/w P1 & P2 above means that I m getting an empty cell. But I don't want it to be like that, I only need is:
Project Name 1
Project Name 2
Bookmarks