N
NEHicks
I have 2 worksheets that contain the same information - name, ss#, date,
unit, discharge appt time, discharge date, discharge time. One sheet is
populated by all people who have discharged and the other sheet is populated
by those who have discharge appointments. Ideally, everyone has a discharge
appt., but that doesn't happen. On worksheet #1, the discharge appt time is
missing. I need to fill that column with the discharge appt time from sheet
2 by matching the name and discharge date. If it works, it will leave a
blank for those who discharged without a discharge appointment. Can anyone
lead me in the right direction for a formula that will accomplish this? I
have tried vlookup, if(vlookup), index and match, but I can't get any of them
to work.
unit, discharge appt time, discharge date, discharge time. One sheet is
populated by all people who have discharged and the other sheet is populated
by those who have discharge appointments. Ideally, everyone has a discharge
appt., but that doesn't happen. On worksheet #1, the discharge appt time is
missing. I need to fill that column with the discharge appt time from sheet
2 by matching the name and discharge date. If it works, it will leave a
blank for those who discharged without a discharge appointment. Can anyone
lead me in the right direction for a formula that will accomplish this? I
have tried vlookup, if(vlookup), index and match, but I can't get any of them
to work.