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?