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
![mrnue.jpg](/board/proxy.php?image=http%3A%2F%2Fi.imgur.com%2Fmrnue.jpg&hash=1b80cf5d5c0f2d4b129a578ce92e06b3)
B: a scheduler
![aFd8E.jpg](/board/proxy.php?image=http%3A%2F%2Fi.imgur.com%2FaFd8E.jpg&hash=c573d9d13c5c2b1e8a93b437426d0fbb)
and C: a test result database
![LR3dc.jpg](/board/proxy.php?image=http%3A%2F%2Fi.imgur.com%2FLR3dc.jpg&hash=3204fe5c745f11cf3610e6624f214b62)
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.