vlookup

[Rohit]

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

 

[L. Howard Kittle]

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]

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]

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.

(e-mail address removed)

Howard

 

[Dave Peterson]

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]

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]

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