if and statements

[Maddyv]

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???

[mewingkitty]

C from which spreadsheet?

[Maddyv]

From Second Spreadsheet.

[Ron Coderre]

A bit vague...but...maybe this?

With
On Sheet2, cells A1:C3

Please Login or Register  to view this content.

and...
On Sheet1, cells A1:B3

Please Login or Register  to view this content.

Then, this formula, on Sheet1 returns the appropriate date from Sheet2

Please Login or Register  to view this content.

Copy that formula down through C3.

Does that help?

[mewingkitty]

Explanation in attachment.
There's many ways to go about this.
Let us know if any of ours work!

mew!

[Ron Coderre]

If the Col_B values happen to be Unique Identifiers (like Employee IDs),
then a formula like this is more appropriate:
On Sheet1

Please Login or Register  to view this content.

Oh...and Col_C needs to be formatted as a date.

Does that help?