Hi
Is there anyway not to display a row or for the formula to display the next result in the formula instead of having my spreadsheet broken up by 0's or blank rows? is there a way to do this?

so in in sheet a1 i have name, b1 i have surname and in c1 i have year group

then in sheet 2 a1 i have name, b1 i have surname and in c1 i have year group

in sheet 2 i enter say year 9 in the year group row then, the formula in sheet 2 a1 would be like

=IF(Sheet1!c5=c5,Sheet1!a2,0)

as you can tell it matches the two year group fields, if they match it displays the name, i would also like this for surname which i have done, however, when it doesn't match it displays a 0 what i would like to do is delete that row or for my formula to look for the next match so there are no empty rows? is that possible

thank you very much!!
Dan