Is it possible to use the lookup function to retrieve objects?

[MAC]

I have a table with a list of names and each name has an object associated
with it. Is it possible to perform a look up by selecting a name that will
return the associated object?

 

[Dave Peterson]

Not using a formula.

But you could use a macro.

JE McGimpsey shares how to do it with pictures:
http://www.mcgimpsey.com/excel/lookuppics.html