Hello:

I need help with a formula. I believe the formula I should be using is a combination if / and. Here's what I'm trying to do:

I'm trying to find 'x' in one spreadsheet in a specific column in another spreadsheet -- at the same time 'y' in the first spreadsheet also has to match another specific column in the second spreadsheet --- if so, then I would like it to return a specific text from the second spreadsheet.

For example:

FIRST SPREADSHEET
A B
1 BobSmith 123456
2 JillJones 789012
3 JonRhodes 345678

SECOND SPREADSHEET
A B C
1 BobSmith 123456 07/29/71
2 JillJones 789012 03/23/62
3 JonRhodes 345678 02/17/61

I'm thinking the formula should be:

=IF(AND(A1=SECOND SPREADSHEET A:A,B1=SECOND SPREADSHEET B:B),C,0)

Any thoughts???