That did it. :) :) :)

I was unaware that I had even created a range named "ajc". I also used
"ajc" as a password to protect the worksheet. I therefore thought the
"ajc" in the formula just referred to the password so as to
temporarilty "unprotect" the sheet while it did it's VLOOKUP. Although
now that I think of it...since the "ajc" could be seen in the function,
it wouldn't really be a secure password now would it?

Thank you SO much for your assistance. You da man Ron!

SnotRockit


--
SnotRockit
------------------------------------------------------------------------
SnotRockit's Profile: http://www.excelforum.com/member.php...o&userid=28618
View this thread: http://www.excelforum.com/showthread...hreadid=482797