IF lookups with multiple condition arrays - I think?

[shellwig]

Is there a formula that gives me this result when searching through?

IF Column B = (FL5DOxxx1, FL5DOxxx2... FL5XBxxx) then result = "FI" but
IF Column B = (FL5N1****) then result = "NEA"

 

[63falcondude]

If I understood your request correctly, try =IF(OR(LEFT(B2,5)={"FL5DO","FL5XB"}),"FI",IF(LEFT(B2,5)="FL5N1","NEA",""))

 

[shellwig]

The formula is not pulling the "NEA" name but I can take it from here. Thank you!

 

[63falcondude]

The formula is not pulling the "NEA" name but I can take it from here. Thank you!

Glad to help. The formula would only result in NEA when the first 5 characters of B2 are "FL5N1".