Make sure you have selected the cell, not the logo/image. Here are the steps to create a linked picture: In this part, we create a linked picture using any of the existing images/logos. The above steps would give you a drop-down list in cell E3. Select the range that has the club names (B3:B22 in this example).This will allow you to select the cells in which you have the list for the dropdown. In the Source field, click on the upward-pointing arrow icon.In the Data Validation dialog box, within the Settings tab, make sure List is selected in the Allow drop-down (if not selected already).Click on the Data Validation option (it’s in the data tools category).Select the cell in which you want the drop-down (E3 in this example).You can resize the images so that these are within the cell, or you can expand the cells. Make sure the logos fit nicely within the cell. In the adjacent column, insert the picture for the item (club logo in this example).Have the names of all the items (team names) in a column.Let’s go through these steps in detail now. Creating a drop-down list to show item names (club names in this example). There are four parts to creating this picture lookup in Excel: Now what I want is to be able to select a team name from the drop-down, and the logo of that selected team should appear. I have a list of the 20 teams in English Premier league (arranged in an alphabetical order) along with the club logo in the adjacent cell. It’s simple yet it’ll make you look like an Excel Magician (all you need is this tutorial and sleight of hands-on your keyboard).īelow is a video of the picture lookup technique (in case you prefer watching a video over reading). In this tutorial, I will show you how to do a picture lookup in Excel. if I have a list of team names and their logos, and I want to look up the logo based on the name, I can’t do that using the inbuilt Excel function. There are many lookup functions in Excel (such as VLOOKUP, LOOKUP, INDEX/MATCH, XLOOKUP) that can go and fetch a value from a list.īut you can’t look-up images using these formulas.įor example.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |