Hi Biff,

you can add an additional column to create a super index.

If, for example, you need to refer to column A, B and C, you can add a new
column before A and insert in the new column, that will be column A, the
following formula, for example in A2 and then drag down:

=B2&C2&D2

In this way you can refer to this new column.


--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy


Nel ,
Biff ha scritto:
Is there a way to do a Vlookup that refers to more than the first
column of the table. If not, does anyone know an easy way to
connvert a table (multiple rows and multiple columns to a table with
only two columns and multiple rows) so that I can use the vlookup
funtion?