Formula Help

[Shmeetbag]

Looking for a formula for cells G2:K5 to reference table A1:E7. If sale date is <= -5 days from today, and if the status is equal to "F" or "A", then the corresponding data should be returned.

I have tried using an index/match function, but I can't get it to work for 3 criteria.

Any suggestions are appreciated!

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K
1	State	CustomerRef	CustomerName	SaleDate	Status	*	State	CustomerRef	CustomerName	SaleDate	Status
2	AL	1	Dave	3/9/2011	F	*	AZ	2	Tom	3/1/2011	F
3	AZ	2	Tom	3/1/2011	F	*	AZ	2	Tom	3/1/2011	F
4	AZ	2	Tom	3/1/2011	F	*	AZ	2	Tom	3/1/2011	F
5	AL	3	Jason	3/2/2011	A	*	AL	3	Jason	3/2/2011	A
6	CO	3	Jason	3/10/2011	A	*	*	*	*	*	*
7	NV	4	Bill	3/1/2011	B	*	*	*	*	*	*
Sheet2

 

[GlennUK]

Does this have to be done with a formula? With Data/Filter/Advanced Filter it's very easy ( set up criteria as needed first ).