I have an array of data with the first column and the first row being
sizes and the contents of the table being price.

I want to have a drop list where the user selects size a, size b and
gets given the price.

I have successfully done this with HLOOKUP however while the first list
is the values of the first row the second list is the index 1,2,3,4,
etc not the sizes in the first list as I wanted.

How can I get the drop down list to display the actual data from the
first column while returning the index number as required by the
HLOOKUP formula?

Thanks,

Martin