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.
[TABLE="class: grid, width: 582"]
<tbody>[TR]
[TD="colspan: 2"]Data on ''Master List' Sheet is manually altered[/TD]
[TD][/TD]
[TD]Desired Display on Contracts Sheet[/TD]
[TD][/TD]
[TD]Desired Display on Dispatch Sheet[/TD]
[/TR]
[TR]
[TD]BD[/TD]
[TD]Orientation[/TD]
[TD][/TD]
[TD]Business Cards[/TD]
[TD][/TD]
[TD]Chevron Fuel Card[/TD]
[/TR]
[TR]
[TD]Contracts[/TD]
[TD]Business Cards[/TD]
[TD][/TD]
[TD]Agency Access[/TD]
[TD][/TD]
[TD]Shell Fuel Card[/TD]
[/TR]
[TR]
[TD]Contracts[/TD]
[TD]Agency Access[/TD]
[TD][/TD]
[TD]Orientation[/TD]
[TD][/TD]
[TD]Esso Fuel Card[/TD]
[/TR]
[TR]
[TD]Contracts[/TD]
[TD]Orientation[/TD]
[TD][/TD]
[TD]Keys[/TD]
[TD][/TD]
[TD]Fuel Card[/TD]
[/TR]
[TR]
[TD]Contracts[/TD]
[TD]Keys[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Dispatch[/TD]
[TD]Chevron Fuel Card[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Dispatch[/TD]
[TD]Shell Fuel Card[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Dispatch[/TD]
[TD]Esso Fuel Card[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Dispatch[/TD]
[TD]Fuel Card[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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:
[TABLE="class: grid, width: 195"]
<tbody>[TR]
[TD]Display on Dispatch Sheet[/TD]
[/TR]
[TR]
[TD]Chevron Fuel Card[/TD]
[/TR]
[TR]
[TD]Chevron Fuel Card[/TD]
[/TR]
[TR]
[TD]Chevron Fuel Card[/TD]
[/TR]
[TR]
[TD]Chevron Fuel Card[/TD]
[/TR]
[TR]
[TD]Chevron Fuel Card[/TD]
[/TR]
[TR]
[TD]Chevron Fuel Card[/TD]
[/TR]
[TR]
[TD]Shell Fuel Card[/TD]
[/TR]
[TR]
[TD]Esso Fuel Card[/TD]
[/TR]
[TR]
[TD]Fuel Card[/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="class: grid, width: 582"]
<tbody>[TR]
[TD="colspan: 2"]Data on ''Master List' Sheet is manually altered[/TD]
[TD][/TD]
[TD]Desired Display on Contracts Sheet[/TD]
[TD][/TD]
[TD]Desired Display on Dispatch Sheet[/TD]
[/TR]
[TR]
[TD]BD[/TD]
[TD]Orientation[/TD]
[TD][/TD]
[TD]Business Cards[/TD]
[TD][/TD]
[TD]Chevron Fuel Card[/TD]
[/TR]
[TR]
[TD]Contracts[/TD]
[TD]Business Cards[/TD]
[TD][/TD]
[TD]Agency Access[/TD]
[TD][/TD]
[TD]Shell Fuel Card[/TD]
[/TR]
[TR]
[TD]Contracts[/TD]
[TD]Agency Access[/TD]
[TD][/TD]
[TD]Orientation[/TD]
[TD][/TD]
[TD]Esso Fuel Card[/TD]
[/TR]
[TR]
[TD]Contracts[/TD]
[TD]Orientation[/TD]
[TD][/TD]
[TD]Keys[/TD]
[TD][/TD]
[TD]Fuel Card[/TD]
[/TR]
[TR]
[TD]Contracts[/TD]
[TD]Keys[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Dispatch[/TD]
[TD]Chevron Fuel Card[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Dispatch[/TD]
[TD]Shell Fuel Card[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Dispatch[/TD]
[TD]Esso Fuel Card[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Dispatch[/TD]
[TD]Fuel Card[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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:
[TABLE="class: grid, width: 195"]
<tbody>[TR]
[TD]Display on Dispatch Sheet[/TD]
[/TR]
[TR]
[TD]Chevron Fuel Card[/TD]
[/TR]
[TR]
[TD]Chevron Fuel Card[/TD]
[/TR]
[TR]
[TD]Chevron Fuel Card[/TD]
[/TR]
[TR]
[TD]Chevron Fuel Card[/TD]
[/TR]
[TR]
[TD]Chevron Fuel Card[/TD]
[/TR]
[TR]
[TD]Chevron Fuel Card[/TD]
[/TR]
[TR]
[TD]Shell Fuel Card[/TD]
[/TR]
[TR]
[TD]Esso Fuel Card[/TD]
[/TR]
[TR]
[TD]Fuel Card[/TD]
[/TR]
</tbody>[/TABLE]
How do I not return a duplicate value until the formula finds a new match?