Enzo_Matrix
Board Regular
- Joined
- Jan 9, 2018
- Messages
- 113
Is it possible to use VLOOKUP to pull images from my table?
If not VLOOKUP, is there a way?
If not VLOOKUP, is there a way?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
vlookup on images
- Thread starter Enzo_Matrix
- Start date
Fluff
MrExcel MVP, Moderator
- Joined
- Jun 12, 2014
- Messages
- 90,409
- Office Version
- 365
- Platform
- Windows
Yes it's possible, have a look here https://trumpexcel.com/picture-lookup/
Upvote
0
Enzo_Matrix
Board Regular
- Joined
- Jan 9, 2018
- Messages
- 113
Thanks Fluff,
That is an interesting method. My list has over 1000 items and growing. I don't like the fact that I have to use data validation for the referencing.
Could there be a VBA option that will let me use user input instead of a list?
That is an interesting method. My list has over 1000 items and growing. I don't like the fact that I have to use data validation for the referencing.
Could there be a VBA option that will let me use user input instead of a list?
Upvote
0
Fluff
MrExcel MVP, Moderator
- Joined
- Jun 12, 2014
- Messages
- 90,409
- Office Version
- 365
- Platform
- Windows
Almost certainly yes.
However I've never used images on a worksheet, so not sure how to do it.
If you want to use VBA rather than Vlookup, which you asked for.
Then you will need to start a new thread & give some more information.
However I've never used images on a worksheet, so not sure how to do it.
If you want to use VBA rather than Vlookup, which you asked for.
Then you will need to start a new thread & give some more information.
Upvote
0
