Thread: Nested IF?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toria Toria is offline
external usenet poster
 
Posts: 38
Default 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?