vlookup

how can i use vlookup to return value using the col_index_num to be a cell
refence instead of column number.

=vlookup(...............,2,false) to be

=vlookup(................a1,false)

cheers

This seems to work for me, where the lookup value is in A2 and the lookup
column is in A1. Change A1 and it selects a different column to return.

=VLOOKUP(A2,D1:G3,A1,0)

In certain cases, which escapes me now, you may have to use INDIRECT(A1) to
make it work.

HTH
Regards,
Howard

"Rohit" wrote in message
...
how can i use vlookup to return value using the col_index_num to be a cell
refence instead of column number.

=vlookup(...............,2,false) to be

=vlookup(................a1,false)

cheers

Hi
for some reason its not working. i got my working...

sheet 1 (orginal)
co co co co co
1 2 4 5 6

CASH 1000 2000 3000 4000 5000

sheet 2 (with formula)
co co co co co
1 2 4 5 6

CASH CASH 1000 3000 4000 5000
note 2000 is missing




"L. Howard Kittle" wrote:

This seems to work for me, where the lookup value is in A2 and the lookup
column is in A1. Change A1 and it selects a different column to return.

=VLOOKUP(A2,D1:G3,A1,0)

In certain cases, which escapes me now, you may have to use INDIRECT(A1) to
make it work.

HTH
Regards,
Howard

"Rohit" wrote in message
...
how can i use vlookup to return value using the col_index_num to be a cell
refence instead of column number.

=vlookup(...............,2,false) to be

=vlookup(................a1,false)

cheers

I am not understanding the layout and what you are trying to do.

If you want, send me an example workbook with detailed instructions of what
you want to happen.



Howard

"Rohit" wrote in message
...
how can i use vlookup to return value using the col_index_num to be a cell
refence instead of column number.

=vlookup(...............,2,false) to be

=vlookup(................a1,false)

cheers

Maybe you don't want the column index to be a number. Maybe you're asking how
do you match text in a title (topmost) row (like matching the text in the title
(leftmost) column.

If that's the case, =index(match(),match()) may work for you:
http://contextures.com/xlFunctions03.html
(especially examples 2 and 3.)


Rohit wrote:

how can i use vlookup to return value using the col_index_num to be a cell
refence instead of column number.

=vlookup(...............,2,false) to be

=vlookup(................a1,false)

cheers

--

Dave Peterson

Hi Dave

i want to vlookup value using column header which is 1,8,10 and 14

1 8 10 14

CASH 100 200 300 400
dEBTORS 50 150 150 200
FA 300 400 500 600

see if you can help me



"Dave Peterson" wrote:

Maybe you don't want the column index to be a number. Maybe you're asking how
do you match text in a title (topmost) row (like matching the text in the title
(leftmost) column.

If that's the case, =index(match(),match()) may work for you:
http://contextures.com/xlFunctions03.html
(especially examples 2 and 3.)


Rohit wrote:

how can i use vlookup to return value using the col_index_num to be a cell
refence instead of column number.

=vlookup(...............,2,false) to be

=vlookup(................a1,false)

cheers

--

Dave Peterson

Read Debra's site. It looks like those examples are a perfect fit.

Rohit wrote:

Hi Dave

i want to vlookup value using column header which is 1,8,10 and 14

1 8 10 14

CASH 100 200 300 400
dEBTORS 50 150 150 200
FA 300 400 500 600

see if you can help me

"Dave Peterson" wrote:

Maybe you don't want the column index to be a number. Maybe you're asking how
do you match text in a title (topmost) row (like matching the text in the title
(leftmost) column.

If that's the case, =index(match(),match()) may work for you:
http://contextures.com/xlFunctions03.html
(especially examples 2 and 3.)


Rohit wrote:

how can i use vlookup to return value using the col_index_num to be a cell
refence instead of column number.

=vlookup(...............,2,false) to be

=vlookup(................a1,false)

cheers

--

Dave Peterson


--

Dave Peterson