Thank you for your reply Biff, it may be me but I cant seem to get the
thing to work. I event tried the small little example that Microsoft
provides in the help section under Index and Match and I cant get
either one of them to work, I changed the names to match and i built a
new formula using yours as a guide (not copy and paste) and it just
returns a #NA cell value. Were you able to actually get the cell to
reference one correctly?
I have not used Index and Match functions before, I was looking towards
Vlookup but that was the wrong direction.
Thanks
MG
--
MrvinGover
------------------------------------------------------------------------
MrvinGover's Profile:
http://www.excelforum.com/member.php...fo&userid=5124
View this thread:
http://www.excelforum.com/showthread...hreadid=490074