I am trying to find a name from a list of data on a separate sheet and pull it through to a cell on another sheet:
Sheet1:
<colgroup><col width="166" style="width: 125pt; mso-width-source: userset; mso-width-alt: 6070;">
<col width="140" style="width: 105pt; mso-width-source: userset; mso-width-alt: 5120;" span="2">
<tbody>
</tbody>
Sheet2:
<colgroup><col width="44" style="width: 33pt; mso-width-source: userset; mso-width-alt: 1609;">
<col width="62" style="width: 47pt; mso-width-source: userset; mso-width-alt: 2267;">
<col width="194" style="width: 146pt; mso-width-source: userset; mso-width-alt: 7094;">
<tbody>
</tbody>I have found the below formula which searches for the word "Paid Breaks" and returns "Agent1" to the "Name" column.
Is there a way i can change the formula to then go down the list and return "Agent2" and so on until there are no more values with the word "Paid Breaks"
Sheet1:
Paid Breaks | ||
Name | Break Time Available | Break Time Used |
Sheet2:
Agent1 | OffLine | Paid Breaks |
Agent2 | OffLine | Paid Breaks |
| ||
Is there a way i can change the formula to then go down the list and return "Agent2" and so on until there are no more values with the word "Paid Breaks"