I'm using Excel 2010 on Windows XP.
I would like to vlookup to an excel log that tracks the dates of each time a customer was contacted. The customer may be contacted up to 4 times. I want the vlookup result to be the last time the customer was contacted. Essentially, if E2 is blank I want the result to be D2, if D2 is blank I want the result to be C2 and so forth.
I've come up with the following, but am stuck with how to move forward. I understand why F3 and F4 = FALSE.
=IF(AND(VLOOKUP(A17,A2:E4,5,0)=0,VLOOKUP(A17,A2:E4,4,0)=0,VLOOKUP(A17,A2:E4,3,0)=0),VLOOKUP(A17,A2:E4,2,0))
<colgroup><col span="2"><col><col><col><col><col></colgroup><tbody>
</tbody>
Any assistance is much appreciated!
I would like to vlookup to an excel log that tracks the dates of each time a customer was contacted. The customer may be contacted up to 4 times. I want the vlookup result to be the last time the customer was contacted. Essentially, if E2 is blank I want the result to be D2, if D2 is blank I want the result to be C2 and so forth.
I've come up with the following, but am stuck with how to move forward. I understand why F3 and F4 = FALSE.
=IF(AND(VLOOKUP(A17,A2:E4,5,0)=0,VLOOKUP(A17,A2:E4,4,0)=0,VLOOKUP(A17,A2:E4,3,0)=0),VLOOKUP(A17,A2:E4,2,0))
A | B | C | D | E | F | |
1 | Order ID | Contact 1 | Contact 2 | Contact 3 | Contact 4 | Date of Last Contact |
2 | 15lj | 6/1/16 | 6/1/2016 | |||
3 | 16lj | 6/3/16 | 6/4/16 | FALSE | ||
4 | 17lj | 6/5/16 | 6/7/16 | FALSE |
<colgroup><col span="2"><col><col><col><col><col></colgroup><tbody>
</tbody>
Any assistance is much appreciated!