Compare Two Sheets for Matches in Google Sheets Using MATCH & FILTER Functions - Part 2 

You can actually check for empty by adding RANGE"" into the filter, as the values are treated as if they were in an arrayformula

Can the result copy the highlighted cell and the color of the text? They are all equal part numbers but one list has parts that are end of life (marked by red font) and last time buy (marked by blue font.)

This video was so helpful!! Thank you for sharing!!

This is a thing of beauty!

Can you do this for multiple rows?

How should i go about if I have a re-acuring list of values i need to match. For example: In list 1 i have values that i need to match to list 2,3 and 4 and on list five i have new values that could be in list 3,4 and 6. Should i just add to the formula the range and say it should look something like this ISNUMBER(MATCH(F2,List2!$F:$F,List3$F:$F,0)) or how should i go about it? Thank you in advance!

excelent!!

can you do that by script editor?

This is great, but what if there were multiples of the same stock number in a list? could you store those in an array somehow?

Thank you.. (salute)

You saved me a lot of time :) thanks for the clear explanations. For some reason the comma "," wasn't working for me, I've replaced it with a ";" and it works like a charm !

Thank you!

It is a pity my computer is not good with the graphics cus at the beginning and at 17min it blurs and I couldn't follow. It's a pity!