# Application of a criterion to retrieve data

1. ## Application of a criterion to retrieve data

Hi all,

I'm a bit defeated over this one.

I'm trying to retrieve data in the 'Data' sheet from the relevant station columns C to L and enter them into the columns M to V for the relevant date-time (which are sequential) per station that have the following criterion: the relevant station from columns Z to AI in the 'Criteria' sheet for the respective year/quarter is a "Yes".

I thought index and match functions would work but I'm at a loss.

The attached is a considerably reduced version.

Any suggestions would be greatly appreciated.
Thank you

2. ## Re: Application of a criterion to retrieve data

Where will find the manual mock-up (result values) that you are expecting to retrieve? Formulae that aren't working aren't much use to us.

3. ## Re: Application of a criterion to retrieve data

Hmm, the mock-up result values would be the same as the results in columns C to L in the "Data" sheet with the difference being only data with a corresponding "Yes" in columns Z to AI of the "Criteria" sheet per monitoring station would be shown.

The formula that I'm working with is (with ctrl+shift+enter):

=IF(INDEX(Criteria!\$A\$7:\$AI\$42,MATCH(1,(YEAR(Criteria!\$A\$7:\$A\$42)=YEAR(Data!\$A3))*(Criteria!\$B\$7:\$B\$42=Data!\$B3),0),26)="Yes",C3,"")

4. ## Re: Application of a criterion to retrieve data

Figure it out.
Simplified the year and quarter into one column rather than two for the index match:

=IF(INDEX(Criteria!AB\$4:AB\$155,MATCH(Data!\$C4,Criteria!\$C\$4:\$C\$155,0))="Yes",Data!D4,"")

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1