Hi,

Here's my formula this is giving me grief:
{=INDEX(_Map1,MATCH($C$3,NameRange&"("&AgreementRa nge&")",1),3)}

My formula doesn't seem to be working. My value in $c$3 is "lysell,
kent(17)", and this is value I'm using to lookup the row where this value is
found (on the Summary sheet) in the "_Map1" range. However, I get this lookup
value by catenating "lysell, kent" in column c with "17" in column d
(including concatenating "(" and ")" around the AgreementRange). I would like
the 3rd column in my "_Map1" range. I've named the employee names in column c
"NameRange" and the agreement numbers in column d "AgreementRange".

Any help would be immensely appreciated!

Thanks in advance,

--
Kent Lysell
Financial Consultant
Ottawa, Ontario
W: 613.943.9098