i have tried MEDIAN(IF(SHEET1!A2:A100=SHEET2!A2;SHEET1!B2:B100) )
but it returns either a zero or a #value. even though there is a match the
formula returns false.

entering the matching industry codes in the formula e.g. "100" does not work
either.
do i need to adjust cell format (now"'general")?

thanx.




" wrote:

Hello,

Look he
http://www.bettersolutions.com/excel...N616805002.htm

HTH,
Bernd