How to Lookup Pictures in Excel
If you are familiar of Vlookup function in Excel, it does the job well in finding a value in a table with a given criteria. But have you ever wonder of looking up a picture instead of a value from a table? This tutorial will demonstrate how to do this.
Description of Example
We have a table at ranges A9 to B14 that contains the name of the country and on its right shows the relevant flags. The aim is whenever we change the name of country at cell A4, it will then display the flag at cell B4.
Description of Example
We have a table at ranges A9 to B14 that contains the name of the country and on its right shows the relevant flags. The aim is whenever we change the name of country at cell A4, it will then display the flag at cell B4.
How is it done
First step is to define names through Name Manager under Formulas tab. A small window will pop out to create names.
Add names as shown below. Name 'USA' and it should refer to cell B9, 'UK' for cell B10, and so on.
Assign the name 'Flag' to cell A9 which is our lookup value. Note that we have to use INDIRECT function in referring to cell A9 (highlighted in yellow below figure).
Finally, after defining all the names, select the picture at cell B4 and then type in the formula bar this equation =Flag. Your screen should look like the following picture.
About Us
Excelcrib was founded in November 2017 by Garry, a Microsoft® Office Excel® (MS Excel) enthusiast with background in engineering. He's been using MS Excel for more than 15 years in practice with specialty in VBA.
Contact Us
Follow Us
© Copyright 2023 Excelcrib | Privacy Policy