Looking up values.

Originally Posted by tigeravatar

=SUMPRODUCT(Sheet2!$C$2:$C$352,--(Sheet2!$A$2:$A$352=$A2),--(TEXT(Sheet2!$B$2:$B$352,"mmmm")=B$1))

But this gave me the sum I want to get the actual price or at least an average and the sum did even give me all the prices it missed some

---------- Post added at 02:32 PM ---------- Previous post was at 02:29 PM ----------

didn't* i meant