Would you be willing to develop a VBA macro?
Did a quick search for what you may want and found this at TechGuy
Some useful links to read up on:
For what you want, you may want to use cell References, like a search box.
=if(search(value, cell)>0, true-value, false-value)
In your case
=if(search("1008", A1:A9)>0, t23, "")
Although, i would probably transform A1:A9 into a 1 column Table format or, at least, an expandable NamedRange so you can reference the Range instead of a defined Column/Row definition.
=if(search("1008", lstAgents)>0, t23, "")
Edited 2012-10-15 @ 15:21
Name | ID | NameID
Ted Simpson | 1008 | =[@Name] & " - " & [@ID]
ID columns can be visually hidden and
NameID column, and all others after, can be visual and not actively used, per say.