trying to write a lookup function

[vba_noobie]

Hi there,

I have about 60 columns of numbers, with anywhere between 5 and 50 numbers in each column. I'm trying to write a lookup function where a user can select one of the 60 column identififers from a drop-down menu and it will populate the column below the drop-down menu with the apporpriate numbers from the selected column. I was going to use nested named functions but it's getting out of hand and dI think it would be more efficient to use VBA.

I'm brand new to the language though and have no idea what I'm doing. Can someone pls help?

Thanks

[jeffreybrown]

This should work

=HLOOKUP($A$1,$C$1:$L$33,ROW(A2),0)

The lookup value is in A1

The table spans C1:L33 with the headers in row 1. >> Adjust to fit your needs

Row(A2) will increment as you drag down