Help with formulas

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

thanks so much!