Harry_1234
New Member
- Joined
- Aug 19, 2017
- Messages
- 47
I am looking for a more sophisticated query to compare values of a column in a sheet against multiple sheets and if the value is found return values from a different column. I was able to achieve this with iferror and vlookup but i have about 20 sheets to compare values against.
Sheet1: (Column A is where the values exist to be compared against rest of the sheets and return the values in column B/C/D depending on whichever column has the status data in that particular sheet)
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
<colgroup><col span="2"></colgroup><tbody></tbody>
Sheet3:
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
Sheet1: (Final Result_
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
Sheet1: (Column A is where the values exist to be compared against rest of the sheets and return the values in column B/C/D depending on whichever column has the status data in that particular sheet)
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody> </tbody> | ||||
Sheet2: |
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>
Name | Status |
RED | Deployed |
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
<colgroup><col span="2"></colgroup><tbody></tbody>
Sheet3:
Name | Stage | Status |
Orange | I | Not Deployed |
Blue | II | Not Deployed |
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
Sheet1: (Final Result_
Name | Status |
RED | Deployed |
Orange | Not Deployed |
Blue | Not Deployed |
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>