Thanks Aladin,
=VLOOKUP(I5,'Account Name'!$A$2:$B$100,2,0)
Worked! I had tried VLOOKUP earlier and it failed due to my error in
the formula.
Thanks for taking the time to reply.
--
WilliamVierra
------------------------------------------------------------------------
WilliamVierra's Profile:
http://www.excelforum.com/member.php...o&userid=26107
View this thread:
http://www.excelforum.com/showthread...hreadid=394381