ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Is it possible to use the lookup function to retrieve objects? (https://www.excelbanter.com/excel-discussion-misc-queries/230534-possible-use-lookup-function-retrieve-objects.html)

Mac

Is it possible to use the lookup function to retrieve objects?
 
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

Is it possible to use the lookup function to retrieve objects?
 
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

MAC wrote:

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


All times are GMT +1. The time now is 06:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com