Multiple Reference LOOKUP formula

[macrorookie]

Hello,

I'm trying to cross-reference three sets of criteria to find my result; however, I can't get the VLOOKUP function to perform correctly for this need. Maybe I'm using the wrong function.

I attached a simple workbook to highlight my challenge. The over-simplified language that I included in the attachment, which highlights my problem, is as follows:

IF:
(B5=Sheet2!B4:B12) ---> This line finds the correct row to reference, on the Control sheet.
(year(C2)=Control!C3:E3) ---> This line chooses the correct annual column on the Control sheet, for the given month (e.g., use 2014 assumptions for a 2014 month).
(month(C2)=Control!E14) ---> This line counts the expense only in the month when the expense recurs (e.g., April 2014, April 2015…).

THEN:
SUM(Control!C4:E12) ---> This line finds the specific number based on the criteria above.

Thanks much for any advice!

[cbatrody]

Hi

Please use the following formula in C5.

=IF(AND($B5=Control!$B6,YEAR(Summary!C$2)=Control!$C$3,MONTH(Summary!C$2)=Control!$E$14),SUM(Control!C6:E6),"")

(workbook attached)

[tnvbs]

Hi,
Can you mention result for what you are looking for.. Manual call.

[sktneer]

Not sure what are you trying to do with the month criteria? But try this to see if this is what you are trying to do.

In C3 of Summary sheet......

Please Login or Register  to view this content.

then drag across and down.

For detail see the attached sheet.

[macrorookie]

cbatrody and sktneer,

Both of your solutions worked! Thank you very much.

tnvbs, thank you for responding.