Formula Help for isolating two columns based on NO MATCH

Hi there,

I have uploaded my test excel.

I am looking to pull table data from column's B & C into a separate table only if the adjacent value in column A reads FALSE.

The end goal is to have a two-column table that returns the values in column B & C where the where there is NO MATCH in columns B & D. The common values to search would be in columns B & D, but I don't know how to filter out the matches and only show the non matches while ensuring the data in column B & C are tied together when being returned.

As one can see, I have created column A with the formula ISNUMBER(MATCH(B2,$D:$D,0)) that looks for whether a match is exists in columns B & D with TRUE meaning there is and FALSE meaning there isn't. I could just filter from all "FALSE " data in column A whenever I want to see that data, but I would rather it have its own tab (EG. "NO HISTORY") where it automatically populates the values in column B that have no matches (along with adjacent column C).

Any help would be appreciated!

Thanks for the reply! This returns a table of the matches in columns B&D.

I am looking to have the unmatched values in column B (and adjacent column C) return when compared against column D return into a table.

Thank you again, this worked as spill formula. Ideally, I would like the blank cells in between to disappear and have it come up as its own table.

Wow, this works exactly! I had spaces in those cells to remove the 0's that appeared on another sheet in previous formula trials that were unsuccessful. I will remove these.

You're a magician! How many years did it take you to learn how to do this so quickly??

Originally Posted by Glenn Kennedy

The formula I used, gets rid of them by formula, but it's better to return BLANKS, not SPACES from the other formula, that you didn't include.

then this can be used:

=LET(A,'DATA ENTRY '!B2:C100,FILTER(A,(INDEX(A,,1)<>"")*ISERROR(MATCH(INDEX(A,,1),'DATA ENTRY '!D:D,0))))

This is incredible. Thank you a ton

Originally Posted by AliGW

Glenn told you about that - get rid of the space characters in the 'empty' cells in B and C.

Or use this:

=LET(f,FILTER(B2:C37,NOT(ISNUMBER(MATCH(B2:B37,D2:D37,0)))),FILTER(f,INDEX(f,,1)<>" "))

I did miss it but this works also! You're a wizard too! Thank you very much. I honestly have no clue what I'm reading between both formulas that work but both results are exactly what I'm looking for. I'm looking for some solid beginner courses for excel. I need to learn the language.