 |
| Excel Picture Lookup: 5 easy steps for dynamic images |
Learn to quickly lookup different pictures based on the value of a cell. Some people call this VLOOKUP on images. You can use this technique for company logos, employee pictures, flags - basically anywhere where you need to show different images based on the value of a cell.
You'll also learn a few other techniques here. For example:
- How to work with Excel's picture tools (Crop images, align etc)
- How to use Name Manager to assign names to cells and how to do it quickly with "Create from Selection" option
- A little bit about the INDIRECT function (find out more with the below link)
- How to link pictures to cells
Related Topics:
Post a Comment