Need help with if statement

Column A has text that may appear as follows:
300-3000-000-000-000
300-3490-IRE-CAP-555
100A860
300-3230

I'm trying to write a formula that will return a "label" of PROJECT for all text that appears as 3**-***, etc. All others should be "labeled" SHARED or some other defining text.

Currently A1 = 300-3219-CNS
A2 = 100A860

H1 = SHARED

I've written the formula as
=IF(A1="3*","PROJECT",H1)

It returns the formula as H1 or SHARED and I want it to return PROJECT.

I've replaced the * with ?, but that doesn't seem to help. Is there a different wildcard I should use?

What am I missing - PLEASE HELP.

Don't think wildcards will work here. If the first number is your only condition to determine PROJECT or SHARED, you will need to truncate all unnecessary alphanumeric values first.

Use this instead.

Please Login or Register  to view this content.

Thank you. That works perfectly.