Thursday, October 16, 2014

yogi_Pull Row By Row Values By Name And Date_Range From Sheet2 Table of Names Date_Ranges And Values

                 Google Spreadsheet   Post  #1797
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Oct-16-2014
post by  Ben~++:
Issue with INDEX(MATCH(
Hi everyone.

I'm trying to construct a formula that does a couple of things:

1. Checks another sheet (Reported Check In) and looks for two specific criteria:
2. Criteria 1: (Q1) a range of dates which will be represented by, for example, "10/1/14 - 10/7/14"
3. Criteria 2: (A34) a specific name
3. If those two things are found, return the contents of the cell in column 4

The formula is below:

=ArrayFormula(INDEX('Reported Check In'!A1:F999,MATCH(1,('Reported Check In'!C:C=Q1)*('Reported Check In'!B:B=A34),0)4))

For some reason though, I've just gotten parse errors. Any help?
Here's a link:

Trying to get a formula that will check against Sheet2, and if there's a match in name and date range, will pull the value of the "count" column.