I am looking for an array formula that will look up all rows in a table and return all data for each row that matches a single criteria. For other reasons I can't use filters and really need to try and accomplish this with a formula.
I have included a basic example below. I would like to lookup all rows in a table on Sheet 1 that match the criteria of table column 'Cleared' = 'No' and then return only the rows that match 'No' on Sheet 2. The formula would be in A2 on Sheet 2 and drag over to C2 and down to (say 10 rows) C11. Any help would be greatly appreciated as this is eluding me. Thank you for your time.
Table with Headers
Table Name = CheckingAccount
Table Range = A1:C6
Sheet 1
A B C
1 Cleared Date Amount
2 No 1/6/13 $35.00
3 Yes 1/6/13 $46.00
4 No 1/8/13 $25.00
5 No 1/9/13 $57.00
6 Yes 1/11/13 $33.00
Sheet 2
A B C
1 Cleared Date Amount
2 No 1/6/13 $35.00
3 No 1/8/13 $25.00
4 No 1/9/13 $57.00
Bookmarks