![]() For example, if I select Arsenal, it returns, C3 and when I select Chelsea, it returns C6. This named range is dependent on the drop-down and when we change the selection in the drop-down, it returns the reference of the cell next to the selected team’s name. ![]() We changed that reference with the named range. When we created a linked picture, it was referring to the original cell from which it was copied. How does this Picture Lookup Technique work? That’s it!! Change the club name from the drop-down and it will change the picture accordingly. Delete this cell reference and type =ClubLogoLookup. You will notice a cell reference in the formula bar (for example =$C$3).
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |