Thread: [Solved] Need help with a formula
View Single Post
 
Old 04-25-2017, 05:55 AM
haginho haginho is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Apr 2017
Posts: 3
haginho is on a distinguished road
Default

Please find attached (not the original data, but it fully emulates the task ahead)

The formula should display true if the user has a country code and country name assigned and it matches the data in the second table so in the case of Patrick Sandwich it should show false (I didn't add an example where data in one field is missing but it should also show as false).
Attached Files
File Type: xlsx SampleData.xlsx (8.3 KB, 10 views)
Reply With Quote