Hey Folks,
I'm trying to display only the value of 'Master List'!B:B where 'Dispatch'!$A$1 appears in 'Master List'!A:A.
<tbody>
</tbody>
On the individual Dispatch sheet, I tried using
=IFERROR(INDEX('Master List'!B2:B400,MATCH($A$1,'Master List'!A2:A400,0)),"")
but the results I get are:
<tbody>
</tbody>
How do I not return a duplicate value until the formula finds a new match?
I'm trying to display only the value of 'Master List'!B:B where 'Dispatch'!$A$1 appears in 'Master List'!A:A.
| Data on ''Master List' Sheet is manually altered | Desired Display on Contracts Sheet | Desired Display on Dispatch Sheet | |||
| BD | Orientation | Business Cards | Chevron Fuel Card | ||
| Contracts | Business Cards | Agency Access | Shell Fuel Card | ||
| Contracts | Agency Access | Orientation | Esso Fuel Card | ||
| Contracts | Orientation | Keys | Fuel Card | ||
| Contracts | Keys | ||||
| Dispatch | Chevron Fuel Card | ||||
| Dispatch | Shell Fuel Card | ||||
| Dispatch | Esso Fuel Card | ||||
| Dispatch | Fuel Card |
<tbody>
</tbody>
On the individual Dispatch sheet, I tried using
=IFERROR(INDEX('Master List'!B2:B400,MATCH($A$1,'Master List'!A2:A400,0)),"")
but the results I get are:
| Display on Dispatch Sheet |
| Chevron Fuel Card |
| Chevron Fuel Card |
| Chevron Fuel Card |
| Chevron Fuel Card |
| Chevron Fuel Card |
| Chevron Fuel Card |
| Shell Fuel Card |
| Esso Fuel Card |
| Fuel Card |
<tbody>
</tbody>
How do I not return a duplicate value until the formula finds a new match?
