VLOOKUP would be an excellent way of doing this. The only limitation is
that the lookup column must be the leftmost column of the table. If it
isn't you can create an extra column on the left and link by =
formula.
--
mrice
Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile:
http://www.excelforum.com/member.php...o&userid=10931
View this thread:
http://www.excelforum.com/showthread...hreadid=545951