I have a worksheet with a field I'll call function code (FC). I want to
populate a field in each row depending on what the FC is. Example, I want
this new field to be 10 if the FC begins with "40", 20 if it begins with
"412", 30 if it begins with "42" but not "423". Is this possible? Maybe
with a vba routine?