I'm looking for 1 of the 3 types of statuses (Not Started, Pending, Approved) according to the project ID, project Name, and the current phase Define (in header) from worksheet 1 and value to be returned in worksheet 2
Worksheet 1 - formula in cell C2
<tbody>
</tbody>Looking for "Approved" in cell C2
Worksheet 2 - Source Data
<tbody>
</tbody>
*"Define Yr" End is not the same as "Define", looking for status of "Define" only.*
So, to reiterate, in worksheet 1 cell C2, looking to return the "Approved" Status for Define for Project 310122 Money Service.
Appreciate any assistance!
-DCotex
Worksheet 1 - formula in cell C2
A | B | C | |
Column Headers | Project ID # | Project Name | Define QA Status |
310122 | Money Service | ? |
<tbody>
</tbody>
Worksheet 2 - Source Data
A | B | C | D |
Project ID | Project Name | Status | Phase |
310126 | AML Card | Approved | Define |
310126 | AML Card | Not Started | Expand |
310122 | Money Service | Approved | Define |
310122 | Money Service | Pending | Expand |
310122 | Money Service | Not Started | Define Yr End |
<tbody>
</tbody>
*"Define Yr" End is not the same as "Define", looking for status of "Define" only.*
So, to reiterate, in worksheet 1 cell C2, looking to return the "Approved" Status for Define for Project 310122 Money Service.
Appreciate any assistance!
-DCotex