If error vlookup how to get it to skip a cell that does not match

[SoozToad]

HI everyone, this is my formula which is pretty basic as i am not a super user of excel!! I have this copied down a column so it looks at the next row each time and returns if there is a match - however, i now have a column that has a lot of blank cells where this is no match - is there a way to stop it leaving empty rows please? Thank you very much in advance for all your help - Sue

=IFERROR(VLOOKUP($A$1,'Session Allocation'!E4:F4,2,0),"")

 

[Mentor82]

Hi,
I do not realy get what problem you face. Just to clarify, you pick value from column A you search it then in column E, then the problem you have is: You find that value in column E but the return value from colum F is blank and you' d loke to skip it and to go to another row in colum E with value drom col A where the data in col F is noy blank?
Is it the issue you're facing with?
Regards,
Sebastian

 

[Fluff]

How about the following Array formula
=IFERROR(INDEX('Session Allocation'!$f$2:$f$100,SMALL(IF('Session Allocation'!$e$2:$e$100=$a$1,ROW('Session Allocation'!$e$2:$e$100)-ROW('Session Allocation'!$e$2)+1),ROWS($1:1))),"")

Confirmed with Ctrl Shift Enter, not just Enter

 

[SoozToad]

How about the following Array formula
=IFERROR(INDEX('Session Allocation'!$f$2:$f$100,SMALL(IF('Session Allocation'!$e$2:$e$100=$a$1,ROW('Session Allocation'!$e$2:$e$100)-ROW('Session Allocation'!$e$2)+1),ROWS($1:1))),"")

Confirmed with Ctrl Shift Enter, not just Enter

This works perfectly thank you so much

 

[Fluff]

You're welcome & thanks for the feedback