yogi_Compute Average Of Multiplier Values (read from Sheet2) for ROTX Entries Which Have Date in Column B = That In C3

Google Spreadsheet   Post  #2224

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Aug-12-2017
question by: Sergio Ochoa

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/QXBCSG75IFk;context-place=mydiscussions

How do I combine these averageif and lookup functions?

I gave it my best shot and I am admitting defeat. Can someone help?

I am looking for a way to get the average values of the letters in sheet 1, column A with those that match column B with the value in C:2 (7/31). The result should be 2.4 (Average of 10,2,1,0,-1).

Sheet 2 has the purpose of holding the multiplier values so I can go to one place and change them if need be.

Thoughts on how to do this?

Sheet 1

	A	B	C
1	ROTX	Date	Searching for
2	A	7/31	7/31
3	B	7/31
4	C	7/31
5	D	7/31
6	F	7/31
7	A	8/2
8	A	8/3
9	A	8/4
10	B	8/5
11	B	8/6

Sheet 2

	A	B
1	ROTX	Multiplier Value
2	A	10
3	B	2
4	C	1
5	D	0
6	F	-1