ComboBox Listfillrange

Hi everyone,

I need some help with a ComboBox:

I have two ranges in column A and B respectively. The first range, which I named "page" describes a given page within a magazine (i.e. color third page, BW back page, etc, etc). The second range, which I named "value", shows the value for paid advertising in the page described in the previous column.

What I need is to make a ComboBox that allows me to choose any page type from the drop down menu and, by doing that, automatically obtain the value of advertising in that page in a LinkedCell, let's say, C1.

So far, I've only been only able to make the ComboBox with a simple drop-down menu with the page types, and with a LinkedCell showing those same page types, not the value

Any suggestion?