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     www.energyefficientbuild.com.   Oct-16-2014
post by  Ben~++:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/A28sFCbIOlA)
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: https://docs.google.com/a/vcu.edu/spreadsheets/d/1ey9r6Odc1RkOb2k4K-RVpLVC2DmoLlmLAwTUee9WRmQ/edit#gid=0

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. 
-----------------------------------------------------------------------------------------------------------------------------------