I'm working with 2 spreadsheets with 3 columns: Bank #(Col A), Branch #(Col B) and Branch Name(Col C). I need to identify those branches where the bank # matches, if so, does the branch # match, if so, return the branch name. I have tried the following:
=IF('[north listing...