Lookup Pictures in Excel based on a Cell Value - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
Dillan
Hi Mynda. I noticed as you created the pivot table for the Slicer, your Stage data was sorted correctly with no further changes. When attempting to produce the same, my data was sorted from stage 1 to 19 followed by 2 etc. Could you kindly advise if you had perhaps already created a custom order elsewhere? I can manually change the sort order of the pivot to align however when creating the slicer, I have the same issue. Stages are not in numeric order. Thank you.
reply
Hi Mynda. I noticed as you created the pivot table for the Slicer, your Stage data was sorted correctly with no further changes. When attempting to produce the same, my data was sorted from stage 1 to 19 followed by 2 etc. Could you kindly advise if you had perhaps already created a custom order elsewhere? I can manually change the sort order of the pivot to align however when creating the slicer, I have the same issue. Stages are not in numeric order. Thank you.
reply
jan
What if I don't want to use a drop downlist but another list? I've got my list with pictures and in another tab I create a list of items from the first list. The pictures of the first list should appear alongside the items of the second list.Say I have a list of animals with corresponding pictures; monkee, deer, elephant, rhino, beaver, lion and I have second list with monkee and lion. How do I get the right pictures to show up in the second list?
reply
What if I don't want to use a drop downlist but another list? I've got my list with pictures and in another tab I create a list of items from the first list. The pictures of the first list should appear alongside the items of the second list.Say I have a list of animals with corresponding pictures; monkee, deer, elephant, rhino, beaver, lion and I have second list with monkee and lion. How do I get the right pictures to show up in the second list?
reply
20Lukas93
the linked images get very blurry, and I don't seem to be able to fix this.
The original pictures are imported at the desired resolution. but when it's displayed where I want it to be displayed, the image is blurry.
by the way: i want to use this function to change the logo, based on the department selected of the company. (each department has it's unique color)
thx in advance!
reply
the linked images get very blurry, and I don't seem to be able to fix this.
The original pictures are imported at the desired resolution. but when it's displayed where I want it to be displayed, the image is blurry.
by the way: i want to use this function to change the logo, based on the department selected of the company. (each department has it's unique color)
thx in advance!
reply
Brendan
I'm getting this problem when i try to link the picture to the slicer, it comes up as -reference is invalid-. I tried this with my own list from a different tutorial where i made my own data and got stuck on the same thing. There must be a setting somewhere that's not allowing me to link the indirect formula to that image, but i don't know where.....
reply
I'm getting this problem when i try to link the picture to the slicer, it comes up as -reference is invalid-. I tried this with my own list from a different tutorial where i made my own data and got stuck on the same thing. There must be a setting somewhere that's not allowing me to link the indirect formula to that image, but i don't know where.....
reply
judacious21
With the slicer method (or with slicer use in general) is there a way to prevent the use of Multi-select (For instances like this where it wouldn't make sense to have multiple stages selected simultaneously)? I could remove the header which removes the multi-select button, but that doesn't prevent the use of ctrl+click to select multiple options.
reply
With the slicer method (or with slicer use in general) is there a way to prevent the use of Multi-select (For instances like this where it wouldn't make sense to have multiple stages selected simultaneously)? I could remove the header which removes the multi-select button, but that doesn't prevent the use of ctrl+click to select multiple options.
reply
itech
Thanks for the tutorial. I am working on a Macbook Pro. Any idea why the images inserted (with lookup) are not the same size as the images on the images tab? -size- is actually the same, but only see the upper left corner of the image. this is both on my local file and yours that I downloaded.
reply
Thanks for the tutorial. I am working on a Macbook Pro. Any idea why the images inserted (with lookup) are not the same size as the images on the images tab? -size- is actually the same, but only see the upper left corner of the image. this is both on my local file and yours that I downloaded.
reply
Samia
Hello,
I followed the video, but when I put the named range in place of image it gives me error 'Reference not valid'. Tried doing it again by following the steps you mentioned carefully but still cant get it right. Any suggestions what could be going wrong? I am using Excel 2010
reply
Hello,
I followed the video, but when I put the named range in place of image it gives me error 'Reference not valid'. Tried doing it again by following the steps you mentioned carefully but still cant get it right. Any suggestions what could be going wrong? I am using Excel 2010
reply
William
HI, I was wondering is it possible to show an image without a drop-down menu? I have a league table where the teams move up and down depending on the results obtained, so would like the pic in a cell next to the cell with the name of the team. Any advice would be appreciated.
reply
HI, I was wondering is it possible to show an image without a drop-down menu? I have a league table where the teams move up and down depending on the results obtained, so would like the pic in a cell next to the cell with the name of the team. Any advice would be appreciated.
reply
Emilia
I followed the video, but when I put the named range in place of image it gives me error 'Reference not valid'. Tried doing it again by following the steps you mentioned carefully but still cant get it right. Any suggestions what could be going wrong? I am using Excel 365
reply
I followed the video, but when I put the named range in place of image it gives me error 'Reference not valid'. Tried doing it again by following the steps you mentioned carefully but still cant get it right. Any suggestions what could be going wrong? I am using Excel 365
reply
Justin
What effect does resizing the presentation level picture have? Could you start with very large images and resize smaller on the presentation sheet? Could be great for dashboards in the charts were placed in a single cell.
reply
What effect does resizing the presentation level picture have? Could you start with very large images and resize smaller on the presentation sheet? Could be great for dashboards in the charts were placed in a single cell.
reply
Add a review, comment
Other channel videos
11:15
5:53
