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