Home » Forums » Open Source Learning Center » Question and Answer

Vlookup with mulitple column ref outputs

Submitted by moremeba on 11 August, 2009 - 12:02

Hi All, i am trying to use vlookup but need to ref more than one column output eg: col_num_ind 2, 3, 4 etc.

Is this possible to do with this function? Is there a work around?

Any help greatly appreciated.

Thanks in advance

moremeba

‹ Automate tasks in a macro or VBA script Excel Workbooks ›
»

Replace column number with COLUMN()

Submitted by Cyril Myshkin on 9 December, 2009 - 07:16.

 Example:

=VLOOKUP(A1,tbl,COLUMN(),FALSE)

»
Nick's picture

VLOOKUP

Submitted by Nick on 16 August, 2009 - 20:18.

Create another column, and concatenate the other columns, then VLOOKUP on that.

 

»