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