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,""))

Jamil

Bronze Contributor

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
- Jamil
  Bronze Contributor
  Apr 04, 2018
  You are welcome.