How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask ATLPROG Your Own Question
ATLPROG, Computer Software Engineer
Category: Programming
Satisfied Customers: 7677
Experience:  MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML
Type Your Programming Question Here...
ATLPROG is online now
A new question is answered every 9 seconds

I have two columns of text in an Excel Spreadsheet. The

Customer Question

I have two columns of text in an Excel Spreadsheet.
The first column is as follows: Advanced Portfolio Management
In the columns to the right, I want it fill in the word "Trade Finance" wherever it sees the word Portfolio. I might have another cell that says Financial Advisor. Again, if sees the word or the same words in that cell, I want Trade Finance to go to the cell next to it on the right. I can't figure out the formula.
Submitted: 1 year ago.
Category: Programming
Expert:  Ingo U replied 1 year ago.


could you upload a sample file with some annotations perhaps, where you've manually performed the step(s) you want to produce with a formula? I can't quite picture what you're after. Also what version of excel do you have?


Ingo U

Related Programming Questions