Is it possible to have a formula that says: "IF A3 "begind with 'P' return a
value of 'ELECTRICAL' in cell G3" or is this type of formula to complex for
Excel to handle? I am attempting to have certain cells fill in automatically
based on imported data.
Thanks,
Samantha