Expert formula help needed

[mistahmistah]

Hello,

I need to create a formula to search for three fields of criteria A1 "Year" A2 "Month" A3"Status" then pull the A4 "Approvals" to a different summary spreadsheet. Keep in mind the number that I need will actually be in column B, but the table descriptions of data are placed in column A. Please use the below as an example, but I would like a dynamic formula to be able to extend beyond being specific to location as next month column B will be "June."

[TABLE="width: 500"]
<tbody>[TR]
[TD]Year[/TD]
[TD]2014[/TD]
[/TR]
[TR]
[TD]Month[/TD]
[TD]May[/TD]
[/TR]
[TR]
[TD]Status[/TD]
[TD]Approved[/TD]
[/TR]
[TR]
[TD]Approvals[/TD]
[TD]125[/TD]
[/TR]
</tbody>[/TABLE]


Thank you!

Hello,

I need to create a formula to search for three fields of criteria A1 "Year" A2 "Month" A3"Status" then pull the A4 "Approvals" number to a different summary spreadsheet. Please use the below as an example, but I would like a dynamic formula to be able to extend beyond being specific to location as next month column B will be "June."

[TABLE="class: cms_table, width: 500"]
<tbody>[TR]
[TD]Year[/TD]
[TD]2014[/TD]
[/TR]
[TR]
[TD]Month[/TD]
[TD]May[/TD]
[/TR]
[TR]
[TD]Status[/TD]
[TD]Approved[/TD]
[/TR]
[TR]
[TD]Approvals[/TD]
[TD]125[/TD]
[/TR]
</tbody>[/TABLE]



Thank you!

 

[Aladin Akyurek]

I'm aware of how to use array formulas.

I had some formatting inconsistencies between what you have and what I have, but i was able to edit it and make it work. Thank you very much Aladin![/QUOTE]

Happy to hear that. Thanks for providing feedback.