Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Nested if | Excel Worksheet Functions | |||
Help Nested If and And | Excel Worksheet Functions | |||
nested if based on nested if in seperate sheet. how? | Excel Worksheet Functions | |||
Nested IF | Excel Discussion (Misc queries) | |||
Nested if | Excel Worksheet Functions |