The struggle to manage Sales Report can consume your time and effort and overwhelm you. But no more - DocHub is here to take the hard work out of modifying and completing your documents. You can forget about spending hours editing, signing, and organizing papers and worrying about data protection. Our platform provides industry-leading data protection measures, so you don’t need to think twice about trusting us with your sensitive info.
DocHub supports different file formats and is accessible across multiple systems.
in this video Im going to show you a couple of ways you can look up pictures based on a value in a Cell linked either to a data validation list or a selection made in a slicer and theres no VBA or macros involved just a couple of basic formulas now Im using some images of the tour to France race stages but you could use this technique with product images employees logos anything really lets take a look the first step is to bring your image into the Excel file now each image needs to sit inside a single cell and you can see here cell A1 its actually quite large but the image sits perfectly inside that cell and its important that the cell is at least as big or slightly bigger than the image because if any part of that image sits outside of the cell youre going to get a distorted result when you look it up so Im just going to contrl zed to pop that back in now you can see here if I go down to the end Ive got 21 images es and its a good idea to distribute them vertically and that
