Picture Lookup

[HanSam]

Hi,

I know it has been asked many times but the explanations I see on the web is too complicated or should I say I am looking for a simpler explanation on how to do what I want.

I have a sheet that only contains two columns, company name and logos. What I aim to do is create sort of a search box, where in when I type a company name on a cell, the picture associated with that company shows up on the cell directly below it.

File's here. The actual images are hidden below the search box and result box.

Defined Names:
SearchBox (B2)
ResultsBox (B4)
tblLogos (A6:B113)

 

[Faseeh]

Hello

Please check attachment. Thanks.

 

[bosco_yip]

1] I reduce your file photo in 50% for easy upload to the forum and remove all define names.

2] Define name to the source data are not required. I set up 2 new define names with dynamic range formula as in :

2.1] Formulas >> Define Name >>

Name : Logo

Refers to : =OFFSET(Sheet1!$A$6,0,,COUNTA(Sheet1!$A:$A)-1)

Use it in B2 :

B2 >> Data >> Data Validation >> Allow : List ; Source : =Logo

2.2] Formulas >> Define Name >>

Name : pic

Refers to : =OFFSET(Sheet1!$B$6,MATCH(Sheet1!$B$2,Sheet1!$A:$A,0)-6,0)

Use it in B4 :

B4 >> Copy/Paste a picture from below >> Click picture >> In the formula bar enter : =pic

3] Please refer to the attached file.

Regards
Bosco