phoenix
phoenixPhoenix - Your AI Assistant
Inactive session will be ended in 24 hours
End Session

Excel formula required to pick specific words from a column on spread sheet

  • Posted:
  • Proposals: 14
  • Remote
  • #1224384
  • Awarded
JM R.Valeriy S.Prasad S.Sajeeb K.Hermon A. + 9 others have already sent a proposal.
  • 1

Description

Experience Level: Entry
Description of excel work: Please see the attached spread sheet which contains a list of product descriptions from a range of around 200 different suppliers.

I want to be able to write the supplier name, i.e. ' Battlefront' in cell C2 and then for the formula in column D to place the word 'Battlefront' in any cells in column D which matches a word in column B. Wherever there is an empty call in column D I will need to write the supplier name in column C. Eventually I hope to end up with a list in column D of all suppliers on the sheet.

All I need is for someone to enter the formula and complete a few examples to prove it works before sending the sheet back to me. The first person who replies with the correct formula will be paid.

Thanks,

Paul
Extra notes:

New Proposal

Login to your account and send a proposal now to get this project.

Log in

Clarification Board Ask a Question

  • Husan M.

    Enter the following formula in D2:
    =IF(IF(SEARCH(C2,B2)>0,C2,0)=0,"",IF(SEARCH(C2,B2)>0,C2,0))
    then copy it down.
    Husan

  • Bhavna S.

    Hi I have solved and sent you already. Did you receive my proposal?

  • Salma K.

    Hello ! how much your budget ?

  • Tom C.

    Hi, Could you please clarify if what you want is the proposal to include the solution as well? Cheers, Tom