Don't bother trying is the usual advice. If it's hard then there's often a
reason, and the usual reason is that there is an easier solution. Take a
look at VLOOKUP which is usually the better option for this kind of
scenario. that having been said, with no sample data it's kind of hard to
fully make the call.
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------