Forum Discussion

Copper Contributor

Apr 04, 2018

Solved

Excel Formula - formula based on if cell contains

Please help! I am trying to create a formula that will do the following: If cell B2 contains "Inbound" then return data in cell D2, if cell B2 contains "Outbound" then return data in cell C2. Co...

Formulas & Functions

training

Jamil
Apr 04, 2018
This formula will do the job

=IF(ISNUMBER(SEARCH("Inbound",B2)),D2,IF(ISNUMBER(SEARCH("Outbound",B2)),C2,""))

Laura Cheeping

Copper Contributor

Apr 04, 2018

Thanks, this worked!

Haytham Amairah

Silver Contributor

Apr 04, 2018

Hi Laura,

If the second formula didn't work, I guess that there are some leading spaces around the Inbound and Outbound texts!

If so, you can solve this with TRIM function as follows:

=IF(TRIM(B2)="Inbound",D2,IF(TRIM(B2)="Outbound",C2,""))

But if the Inbound or Outbound is part of a text such as (Outbound flight), you can use the formula suggested by Jamil.

Regards