What do you mean? I've never heard about a lookup function in T-SQL. I know that there is a lookup function in reporting services to use in expressions...
In T-SQL you need to do a join I think.
No, you're never too old to Yak'n'Roll if you're too young to die.