Formula # 1:
Sheet (A) in column D has a person's initials and the sales price in column H associated with that person.
I need a formula where I can type the person's initials on (Sheet (B) cell A2) and the formula finds each price on Sheet (A) associated with those initials and displays that person's price in their column on Sheet (B).
Formula # 2:
With Formula # 1 completed, type in cell A2 initial's "PP". Different price amounts in (Column A) should appear. Each price amount is in a price range category in (Column D). Next to each Price Range is a Cogs Rate (Column E).
Create a formula that finds the correct Price Range (Column D) and multiples each Price (Column A) by the correct Cogs Rate (Column E) and displays each amount in the Cogs Expense (Column B)
Thank you for your help!
Jessica
Hello Jessica, I can create the custom formulas as required. However, I have a few queries. Please check the private message for my suggestions on how to go about it.
Thanks and Regards,
Shikha
I will give u an application where u can select the excel files and click on output button , you will get the required output excel file.
You can use this application any time
Hi,
I am interested to work for your project . I am an expert in excel and VBA Programming in Excel. I have experience working on lot of Excel based projects. I will make sure that I deliver you the best with 100% accuracy in minimum time . Pay me only if you are 100% satisfied with my work, after project delivery. Please see my private message(PM) for more details.
Regards
Fibin
Jessica, sending you sample Excel 2010 file that does exactly what you want,
Happy to provide full file under a Confidentiality and Non-Disclosure Agreement, and you can have it as soon as you pay the Milestone into the site.
More details on Private Message Board
Bob Allen-Turl