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

Year	2014
Month	May
Status	Approved
Approvals	125

<tbody>
</tbody>

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

Year	2014
Month	May
Status	Approved
Approvals	125

<tbody>
</tbody>

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.