comparison function

[NEHicks]

I have 2 worksheets -
Worksheet A
Name, SSN, Discharge Date, Discharge Appointment Time, Discharge Time

Worksheet B
Name, SSN, Ward, Discharge Appointment Date, Discharge Appointment Time,
Discharge Date, Discharge Time

I need to find a formula that will look at Sheet B by SS# and discharge
date, compare that to the SS# and Discharge Date on worksheet A. If the row
matches, then it needs to fill the discharge appointment time cell on
worksheet A. If it doesn't, the cell stays empty and it goes to the next row
and repeats.

I am at a loss and hope that someone has an answer.

 

[smartin]

I have 2 worksheets -
Worksheet A
Name, SSN, Discharge Date, Discharge Appointment Time, Discharge Time

Worksheet B
Name, SSN, Ward, Discharge Appointment Date, Discharge Appointment Time,
Discharge Date, Discharge Time

I need to find a formula that will look at Sheet B by SS# and discharge
date, compare that to the SS# and Discharge Date on worksheet A. If the row
matches, then it needs to fill the discharge appointment time cell on
worksheet A. If it doesn't, the cell stays empty and it goes to the next row
and repeats.

I am at a loss and hope that someone has an answer.

Have a look at

http://www.dailydoseofexcel.com/archives/2009/04/21/vlookup-on-two-columns/