Select All, then New, then Add to table. The following table is an example of the custom table of contents and the results it results in. · Name of the custom table of contents: Picture lookup in Excel [Excel] How to make a picture lookup in Excel in 5 seconds | Excel Geeks How to Add Picture in Excel with Named Ranges in Excel, you use the Name lookup table (the named range) to look up the image for the user. In this tutorial, you will see how to add a picture. Here are the steps. Enter a name for your lookup table and set it up for named ranges. Click the Name lookup in Excel link Click on the Names drop-down list and select the Name of the table. In the Name lookup in Excel link section, you will see an overview of the tables you can create. If any of the named ranges look like a picture, you can find a picture in any one of the named ranges by using the lookup table function. How to make a picture lookup in Excel, a picture lookup guide for beginners How to create picture lookup with Named Ranges in Excel: Create a table of contents (TCO) by adding a new named range and then making the contents blank. If you are a beginner at looking up pictures, go for the name lookup, if you want to learn something new, follow up with the TCO. How to Make a Picture Lookup in Excel — How-to guide Picture lookup in Excel tutorial :- Enter a name for your TCO, and set it up for named ranges. Use the Name lookup in Excel link When you do a Lookup function, then the result that you get may be a picture, or all the names may be just pictures, so if the lookup works on any of the pictures, then they will give you all the names you want to look up. How to Create Picture Lookup in Excel [Excel Blog] Picture lookup in Excel tutorial : Create picture lookup in Excel, step 1 : Enter a name for your lookup table that your picture lookup table will be a part of. If you are making a picture lookup, just set it to picture lookup, if they are just a name and no picture, that will give you a random picture.