# IF lookups with multiple condition arrays - I think?

#### shellwig

##### New Member
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"

### Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

#### 63falcondude

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

#### shellwig

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

#### 63falcondude

##### Well-known Member
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".

Replies
5
Views
585
Replies
1
Views
454
Replies
0
Views
411
Replies
0
Views
307
Replies
6
Views
1K

1,191,719
Messages
5,988,290
Members
440,148
Latest member
sandy123

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back