need a formula that searches football results but only last 6

is there anyone who can help me please??

there is only two things i need.

1. the btts NO ( in orange) is not working properly. btts means both teams to score i.e 1-1

2. the yellow highlighted part of the last 6 games only ive deleted by acident and need to work out how to get a
formula that searches the results for the LAST 6 ONLY.

thank you

Duplicate post: see your previous post where I posted a file.

http://www.excelforum.com/showthread...t=#post4430584