There are two tabs in the Google Spreadsheet.
I need to compare columns B from each tab and identify them as Match/Non-Match
I used Vlookup but for some reasons I does not work.
Here is the link to the file - https://docs.google.com/spreadsheets/d/1CoN2hwj1tmFCiiEJ2iOIkIbIBRRa39N4iOPWr_IGAp0/edit?usp=sharing
=ARRAYFORMULA(IF(B2:B="",,COUNTIF(Staging!B:B,B2:B)>0))
=ARRAYFORMULA(IF(B2:B="",,COUNTIF(Live!B:B,B2:B)>0))