Glad it worked, and thanks for the feedback !

Btw, although this doesn't affect the formula's return
the parens around the last term: .. ,(Sheet3!$F$2:$F$100))
wasn't necessary. My error, just detected.

It should read as just: .. ,Sheet3!$F$2:$F$100)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"JulieU" wrote:
Max,
Thanks so much for your help! It worked perfectly! I had been struggling
with this for days. Thanks again!!