mistahmistah
New Member
- Joined
- May 8, 2014
- Messages
- 21
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."
<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."
<tbody>
</tbody>
Thank you!
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!
Last edited by a moderator: