Lookup the Odd One Out

[KimC]

I have three headings

Heading 1 Heading 2 Heading 3

In some other columns i have for example

Heading 2 Heading 3
Heading 1 Heading 3
Heading 3 Heading 2

In the third column i want the third heading that is not already displayed
to be displayed. So this is the outcome

Heading 1
Heading 2
Heading 1

Any help would be great

 

[JMB]

Assuming your 3 headings are in Sheet1 cells A1:C1 and your other columns
with 2 out of 3 headings start in Sheet2 A1:B1, one suggestion you could try:

=INDEX(Sheet1!A$1:C$1,MATCH(TRUE,ISNA(MATCH(Sheet1!A$1:C$1,A1:B1,0)),0))

array entered with Ctrl+Shift+Enter, then copy down.

 

[KimC]

Thankyou, that worked great!

Assuming your 3 headings are in Sheet1 cells A1:C1 and your other columns
with 2 out of 3 headings start in Sheet2 A1:B1, one suggestion you could try:

=INDEX(Sheet1!A$1:C$1,MATCH(TRUE,ISNA(MATCH(Sheet1!A$1:C$1,A1:B1,0)),0))

array entered with Ctrl+Shift+Enter, then copy down.