klundtasaur
New Member
- Joined
- Jun 28, 2011
- Messages
- 5
Ok, so I've searched for about 3 days now trying to find this elsewhere, but Google has failed me. I've been searching this and a few other forums for 3 hours and keep coming up dry, so here goes:
I have 3 databases i'm pulling from:
A: a server log
,
B: a scheduler
,
and C: a test result database
.
I need to check if there is a match on Date, Time, and Therapist on A and B, and if there is a match, i want to flag the corresponding row on B as TRUE(in Column E: "Looked at").
Then I need to match Date, time, therapist, and patient on B and C, and if there is a match, flag the corresponding row on C as TRUE (in Column D: "Looked at").
I am really a novice at Excel and I'm not sure if this is even possible, but I feel like I can't be the first person to need to do this kind of thing. Thanks so much for your help--if I can't figure out a way to do this with a formula, I've got to go through all 6000 entries by hand...twice.
I have 3 databases i'm pulling from:
A: a server log
B: a scheduler
and C: a test result database
I need to check if there is a match on Date, Time, and Therapist on A and B, and if there is a match, i want to flag the corresponding row on B as TRUE(in Column E: "Looked at").
Then I need to match Date, time, therapist, and patient on B and C, and if there is a match, flag the corresponding row on C as TRUE (in Column D: "Looked at").
I am really a novice at Excel and I'm not sure if this is even possible, but I feel like I can't be the first person to need to do this kind of thing. Thanks so much for your help--if I can't figure out a way to do this with a formula, I've got to go through all 6000 entries by hand...twice.