Lookup based on month

[ammartino44]

I have a list of items with values for different months in tab 2. In tab 1, I have just the values and then a lookup where I can put the month. Can somebody show me how to write a lookup formula for the items? Different methods welcome. Spreadsheet attached.

[FDibbins]

Im sure this has been said before, but it is always easier if you keep your formats the same. You are looking for a date - keep it in date format, not text format. Apr is text, 4/1/14 is date/numeric.

Then use this, copied down...
=INDEX(Sheet1!$B$4:$M$9,MATCH(Sheet2!$A7,Sheet1!$A$4:$A$9,0),MATCH(Sheet2!$D$3,Sheet1!$B$3:$M$3,0))

[AlKey]

Try this one

=SUMPRODUCT((Sheet1!$A$4:$A$9=A7)*(TEXT(Sheet1!$B$3:$M$3,"mmmm")=$D$3)*(Sheet1!$B$4:$M$9))

	A	B
6		Return values
7	ACCRUED WAGES	$ -
8	REGULAR WAGES - SALARY	$ 2,451.18
9	EXECUTIVE SALARY ALLOCATION	$ 35.00
10	PTO	$ -
11	HOLIDAY	$ -
12	OTHER TIME BASED COMP	$ -