SOLVED

Help with formulas

New Contributor

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   
#datevisithow?
5936/28/2021 show
5946/28/2021cancelonline
5956/28/2021 show
5966/29/2021 show
5976/30/2021cancelphone
5986/30/2021 show
5997/1/2021cancelno data
    
sheet 2   
#how  
594online  
597phone  

 

 

thanks so much!

 

 

2 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@dlc54 

In D2:

 

=IF(C2="","show",IF(C2="cancel",IFERROR(VLOOKUP(A2,Sheet2!$A$2:$B$1000,2,FALSE),"no data"),""))

 

Fill down.

@Hans Vogelaar 

Works perfectly.  Thank you