If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
comparison function
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. |
#2
|
|||
|
|||
comparison function
NEHicks wrote:
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/arch...n-two-columns/ |
Thread Tools | |
Display Modes | |
|
|