Formula to export two rows above and two rows below of a "word" to another sheet.

Hi all and thank you in advance to anyone whom is able to help me.

This might be very simple however I have a long bank statement and wish to search for the word lotto, once found I wish for two rows either side to be exported to another sheet.

I would paste an example however I have converted a pdf to an xls and it is very messy..meaning that all of the rows are weird and instead of all of the info being in 4-6 columns it is probably taking up about 200 yet is automatically condensed so I can some what understand what is happening.

Basically this is a formula for a search query and upon receiving the word " lotto" two rows above and two rows below will be automatically exported to another sheet, thus saving me having to got through many lines manually.

Thanks again to anyone whom can help.

EastW00d,

Thank you VERY much for your response.

I will try this method and let you know how I go.

Stoked !