The method of making Excel icon information linkage

The Excel table holds the names of the 108 heroes in the margin, corresponding avatars, nicknames, seating and introductions. In order to browse the convenience, want to make this kind of interactive effect: Use the Drop-down menu to choose the name, the character of the corresponding avatar, nickname, seating and profile will be linked to display (Figure 1). This greatly saves the placeholder space of the display interface.

You know, in Excel to achieve interactive effects, especially when it comes to the effects of pictures, is not easy to achieve. However, we can skillfully use some special functions to achieve this effect.

First, the data table that holds the information about 108 heroes is sorted, the name of the worksheet is "people," and a new worksheet named "Filter" is used for interactive filtering of names (Figure 2).

When the data is ready, make the interaction settings. First, insert a picture in the C5 cell of the filter sheet, and adjust the size; Select D5 cell, click Data validation on the Data tab, select "Sequence" in the settings, select "Source" in the b2:b109 on the person's worksheet (that is, the name column in the People table), so that in the Filter the D5 cell in the table forms a Drop-down menu with a name. Use the Pull-down menu to select a hero's name, such as "Lin Chong". Select E5, F5, G5 cells, and in the formula bar, enter =vlookup (filter! $D $, characters! $B $: $E $109,2,false) "," =vlookup (filter! $D $, people! $B $: $E $109,3,false) "," =vlookup (filter! $D $, characters! $B $: $E $109,4,false) ".

Next is the most important part: Click on the "Formula" tab in the name manager, a new name called "Avatar", referring to the location of "=index" (People! $F: $F, MATCH (filter!) $D $, character! $B: $B,)) "name. Select this picture and type "= Avatar" in the formula bar to adjust the size of the picture to match the size of the cell (Figure 3).

After the completion of the operation, the use of the Drop-down menu to choose the names of different heroes, Avatar, nickname, seating, introduction and so on will follow the corresponding changes. Excel Tutorials

Small tip:

Excel in the text and picture linkage effect is not very cool? The above is only a special case showing the picture of the game. But its realization method is applicable to the text and picture linkage of any occasion, such as all walks of life involved in various types of product information and picture display. I believe it will be useful to you.