I have a spreadsheet where I have two worksheets. On the first worksheet
(intended to be an index sheet), I have a list of numbers (about 30) and
text. On the other worksheet (my "data" worksheet), I have 30 columns of
information, each correlating to one of the numbers on the index worksheet.

I know about hyperlink, but that only links the index page value to another
worksheet. I don't want to create 30 different worksheets to use hyperlink;
my current spreadsheet only has 2 worksheets.

Is there any way to create a link from the index worksheet to a specific
column on the other worksheet, and view the contents on the data worksheet?
The data on the index sheet is not verbatim the data on the other sheet; i.e.
the index sheet might contain a model number, the data sheet might contain
the part number for the model.

Thanks much,

Dave