Forum Discussion
Solved
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 ...
In D2:
=IF(C2="","show",IF(C2="cancel",IFERROR(VLOOKUP(A2,Sheet2!$A$2:$B$1000,2,FALSE),"no data"),""))
Fill down.
In D2:
=IF(C2="","show",IF(C2="cancel",IFERROR(VLOOKUP(A2,Sheet2!$A$2:$B$1000,2,FALSE),"no data"),""))
Fill down.
Works perfectly. Thank you 🙂
