HELP!!!

[David M]

Does anyone know if VLOOKUP has a limit of how many
columns it will parse? here is an example of my problem...

=IF(ISERROR(VLOOKUP(L4,PMDBSTATS,13,FALSE)),"",MID(VLOOKUP
(L4,PMDBSTATS,13,FALSE),1,10))

This will work only to the 12th column...when I go to 13
and 14, it brings me back this strange number not what is
in the cel....I put in some test data to make sure and ran
into the same problem....the formula works until it gets
to column 13....any ideas??

Thanx Much

 

[Trevor Shuttleworth]

David

it depends on the "width" of the named range PMDBSTATS. If it only has 12
columns, that's why it won't work.

Regards

Trevor

 

[Guest]

Actually, the range expands when neeed so it can hold as
many as I need however it is returning strage data..

Thanx

D

 

[Trevor Shuttleworth]

David

maybe you should post the formula that you use to expand the range. Then we
(that's the Royal "we" 'cos it might mean nothing to me) can check/test what
is happening.

Regards

Trevor

 

[Trevor Shuttleworth]

David

I used this to create an expanding named range. Seemed to work OK

=OFFSET(Sheet1!$M$18,,,COUNTA(Sheet1!$M:$M),COUNTA(Sheet1!$18:$18))

If I didn't make the row and column absolute in the COUNTA functions, the
range changed depending on where I copied the formula.

Regards

Trevor

 

[David M]

Hmm....what is strange is I selected the raw data I needed
and then gave it a name...so the rows in question are in
that range ...what baffles me is that it works until I get
to row 13.....

 

[Trevor Shuttleworth]

David

if you add columns or rows in the middle of the range then it will expand to
include those columns and rows but columns to the right or rows below will
not be included in the range.

If you want to post your email address I will contact you out of the group
and, if you wish, you can send me a copy of the workbook.

Regards

Trevor