Hi there.
I will try and be simple. So here goes an example of what i need help with:
STOCK WORKSHEET (Say im selling single apples, pears & oranges at different prices)
A B sell price
----------------------------------------------
Apple - £0.52
Apple - £0.63
Orange - £0.51
Pear - £0.75
Orange - £0.85
Apple - £1.10
FINANCE WORKSHEET (Column C is where i need help...)
A B Sold C average selling price??
-------------------------------------------
APPLE - 3 -??
ORANGE - 2 -??
PEAR - 1 -??
So i need a formula on the Finance page, column C , to look up every APPLE, ORANGE and PEAR entry (Separately) in the STOCK WORKSHEET and then return to me the average selling price in column C on the FINANCE WORKSHEET?
e.g C - look up every APPLE entry on STOCK WORKSHEET (0.52, 0.63 & 1.10) then give me an average of these 3 result in the C column 'APPLE' entry on FINANCE WORKSHEET
I can use lookup and several intermediate function, for example I can create lookup formula for the amount of items sold on another work sheet as in column B on the finance worksheet, but this other issue is just one step too advanced for me to work out?? so please help me.
cheers. Cole.
Bookmarks