Is there a formula that I could use to perform the following.

In one spreadsheet I have a unique no e.g.1018. In another spreadsheet I
have lots of rows some of which have the unique no 1018. I need a formula to
say that if any rows in the second spreadsheet equal 1018 then return all
those rows.

Thanks