The suggested set-up was to closely suit what you described in your post.
The "-2" is a required arithmetic adjustment as the criteria col C's formula
starts in C4 down (as you said the results were to be in B4 down) while the
source data in Sheet2 was assumed to start in row 2 down (this was assumed
as it wasn't mentioned in your post). Anyway I'm glad you tweaked it to suit
what you really had over there <g.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Tsunami3169" wrote in message
oups.com...
Thanks tons!
I had to tweak it a little, I'm not sure why. Once I removed the -2 it
worked like a charm.

Thanks again.