Looking for help to analysis data
for each # on sheet 1
check column c
if blank then in column d enter 'show'
if 'cancel' look up sheet 2
if match for # then enter column b
if no match then enter 'no data'
sample data below
| sheet 1 | | | |
| # | date | visit | how? |
| 593 | 6/28/2021 | | show |
| 594 | 6/28/2021 | cancel | online |
| 595 | 6/28/2021 | | show |
| 596 | 6/29/2021 | | show |
| 597 | 6/30/2021 | cancel | phone |
| 598 | 6/30/2021 | | show |
| 599 | 7/1/2021 | cancel | no data |
| | | | |
| sheet 2 | | | |
| # | how | | |
| 594 | online | | |
| 597 | phone | | |
thanks so much!
