Lookup return multiple values?

[bkube01]

Good morning!

I have a table like the one below that shows a document number and the hours it took to write the document. I'm trying to calculate the averages, medians, percentiles of this table by doc number. I'm guessing something like =AVERAGE(VLOOKUP($A35,$b$1:$b$15,2)) but I can't get the vlookup to return multiple values. Any ideas? Thanks!


Doc Number Hours
58 1.0
340 1.0
550 2.0
550 4.0
555 6.0
650 14.0
650 9.0
650 2.0
760 9.0
760 18.0
760 2.0
800 2.0
800 1.0
800 1.0
910 1.0

 

[lozzablake]

Assuming range is A1:B16 then:

=AVERAGE(IF(B2:B16=1,A2:A16))

etc
which must be entered as an array formula (CTRL+SHFT+ENTR)

 

[bkube01]

Success! Thank you very much!