Question: I need an Excel formula that will search the first column and if its something by apple it will populate into the other column. so

I need an Excel formula that will search the first column and if its something by apple it will populate into the other column. so in this picture example row 5, 6, 8 and 9 would copy over because they are owned by apple. while the other columns would return an empty cell. so i am wondering if there is a way I can search for a keyword. so if company name column contains the string "iTunes" or "Apple" in it copy it over. else leave it blank. Will upvote for correct answer!

F3 fx B Apple company A 1 company name 2 spotify 3 spotify 4 amazon music 5 iTunes-Mexico 6 Apple iTunes 7 youtube music 8 iTunes-Japan 9 iTunes Radio 10 iheartradio 11 12

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

IMPORTANT INFORMATION: IGNORE THE FOLLOWING ON FIRST TAB (AS YOU DO NOT HAVE QUESTIONS TO ANSWER) After developing the performance reports, you will answer questions about the variances and determine...

troduction: In this tab assignment you will create a household budget for yourself using Microsoft Excel A budget is an estimate of expected revenues and expenses for a period of time Follow these...

elaborate a one to two (1-2) paragraph max analysis from your work up to this point. Your report should consider: What business recommendations will you give Label XYZ in regards to the...

pleass hslp ms on hos to complete this assignment with the steps i also attached Font 10 N Company Name Actual Expenses Sheet First Two Quarters of 2021 February June Trends May Total lan Percent of...

1 Exercise 3: Lift and Airfoils The first part of this week's assignment is to choose and research a reciprocating engine powered (i.e. propeller type) aircraft. You will further use your selected...

This case will use an Excel Workbook as a Tutorial Tool (with learning content incorprated into each worksheet). Within the Workbook there will be multiple worksheets that the student will need to...

CAN YOU PLEASE EMAIL ME THE EXCEL SHEET TO BOOKDJX22@ G MAIL.COM EXCEL SKILLS TEST Stock Shares Analysis You have saved $2,100, and you are considering investing your money by buying shares of stock....

Excel preparation Assignment - Saved to this PC Olaide Help Tell me what you want to do Design Layout References Mailings Review Body) 11 A A Aa Ao ... u ob XX A.D.A. EE 1 . View 211 . AaBbCcDc...

I do not understand any of this, and I wondered if anyone could explain it in simple terms? I am confused about how to do this, and my class ends in less than 24 hours. I uploaded everything from the...

A coil having a resistance of 102 and an inductance of 75 mH is connected in series with a 40F capacitor across a 200 V a.c. supply. Determine (a) at what frequency resonance occurs, and (b) the...

Your newest client, Smiles PC, is a dental practice providing comprehensive dental services in the Houston area. The corporation is solely owned by Mark W. Nguyen, DDS, and has been set up as an S...

A hedge fund manager, holds a short position of 5 0 0 shares at $ 5 0 0 per share. To hedge her short position, she employs a collar strategy with an additional twist

Draw a class diagram and its relationship based on the following statements. You can use any UML tool/software to represent your class diagram. Do NOT copy and paste your diagram, use the attachment...