Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have two data extracts which have been joined and ingested into my app. I have two sheets, one for if policy numbers match and give an extract of both data tables into one showing matching policies, and give another extract which shows policy numbers which do not match.
I have the first expression built which works and is fine, however trying the does not match does not seem to work? Any suggestions,
Try this:
=if(dpoPolicyNumber <>PolicyNumberExcel, dpoPolicyNumber)