Excel 2013 does not like the : (colon) between my range cells in this IF statement--
IF(AND(G2='[Base.xlsx]Additional Customers Log'!G:G;K2='[Base.xlsx]Additional Customers Log'!$K$500);"Duplicate";"PendAssignment")
Specifically, G2 holds a company name and K2 holds the company number. I want to compare today's workbook with yesterday's and show which are duplicates and which need to be assigned. I need a match on both the name and number.
In the formula I left the semi-colon instead of a comma as breaks but I've tried it with both and have tried the range both with and without the $ to lock the range in place. I've also tried the generic G:G instead of line numbers but every time i try it, I get the 'we have detected a problem with your formula' pop-up and when I click "Okay', Excel takes me to the first colon between G:G, like it expects a break or another character.
Has anyone done this successfully?
Bookmarks