Hi Franz,

My limitation is that the V-look up function only refers to the first column
in the table array. How do I get it to refer to more than one column. So
if my table array is A2:F25, it wants to refer to only the first column which
is column when looking for the lookup value. How can I get the formula (or
some other formula) to refer to for example column A and B?

Thanks,
Biff

"Franz Verga" wrote:

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?