Nested IF?
I searched in all the areas and I couldn't find this.
I have two spreadsheets. Spreadsheet A has addresses broken out in columns
F through I. The phone number is in column E. Spreadsheet B has addresses
broken out in columns C through F. The phone number is in column B.
Is there a way to do an IF function on spreadsheet B that says find the row
on spreadsheet A that has this phone number and check to make sure the
address cells match?
|