[TABLE="width: 500"]
<tbody>[TR]
[TD]Item 260
[/TD]
[TD]A/C 2121
[/TD]
[TD]Date failed: 15 May
[/TD]
[TD]Fault: B60
[/TD]
[/TR]
[TR]
[TD]Item 260
[/TD]
[TD]A/C 2121
[/TD]
[TD]7 May
[/TD]
[TD]B60
[/TD]
[/TR]
[TR]
[TD]Item 260
[/TD]
[TD]A/C 2003
[/TD]
[TD]3 May
[/TD]
[TD]B60/CS
[/TD]
[/TR]
[TR]
[TD]Item 260
[/TD]
[TD]A/C 2103
[/TD]
[TD]6 Jul
[/TD]
[TD]B60
[/TD]
[/TR]
</tbody>[/TABLE]
I'm trying to build a table that pulls from another automatically and checks to see if my equipment items have failed within a 3 month interval. I've tried using the V/HLookup formula, but I don't know how to program excel to build me a new table based off items failing inspections within a 3 month time period of its last fail date. The first cell is the Item Name, A/C is aircraft #, then date failed, followed by what it failed. How can I use V or HLookup to search a table for an item with recurring fails in a 90 day period?
Thank you!
<tbody>[TR]
[TD]Item 260
[/TD]
[TD]A/C 2121
[/TD]
[TD]Date failed: 15 May
[/TD]
[TD]Fault: B60
[/TD]
[/TR]
[TR]
[TD]Item 260
[/TD]
[TD]A/C 2121
[/TD]
[TD]7 May
[/TD]
[TD]B60
[/TD]
[/TR]
[TR]
[TD]Item 260
[/TD]
[TD]A/C 2003
[/TD]
[TD]3 May
[/TD]
[TD]B60/CS
[/TD]
[/TR]
[TR]
[TD]Item 260
[/TD]
[TD]A/C 2103
[/TD]
[TD]6 Jul
[/TD]
[TD]B60
[/TD]
[/TR]
</tbody>[/TABLE]
I'm trying to build a table that pulls from another automatically and checks to see if my equipment items have failed within a 3 month interval. I've tried using the V/HLookup formula, but I don't know how to program excel to build me a new table based off items failing inspections within a 3 month time period of its last fail date. The first cell is the Item Name, A/C is aircraft #, then date failed, followed by what it failed. How can I use V or HLookup to search a table for an item with recurring fails in a 90 day period?
Thank you!