Hi,
I have a table where the columns are grouped into catagories
0,II,III,IV and V. Each catagory has four columns designated R,C,S and
P,i.e a total of 20 columns. I can't get Vlookup and Index functions
to refer to the columns. A combination of non-numerical values and
catagories of columns has completely boggled my brain. Help please....

When you say grouped in categories do you mean they are named ranges, do
you also know that you cannot return a value to the left of the lookup
value?


--
The Code Cage Team

Regards,
The Code Cage Team
http://www.thecodecage.com
------------------------------------------------------------------------
The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=30001

On Nov 15, 4:31*pm, The Code Cage Team <The.Code.Cage.Team.
wrote:
When you say grouped in categories do you mean they are named ranges, do
you also know that you cannot return a value to the left of the lookup
value?

--
The Code Cage Team

Regards,
The Code Cage Teamhttp://www.thecodecage.com
------------------------------------------------------------------------
The Code Cage Team's Profile:http://www.thecodecage.com/forumz/member.php?userid=2
View this thread:http://www.thecodecage.com/forumz/sh...ad.php?t=30001

No they are not ranges. It's just that I need to be able to refer to
each of the columns by using the input from one cell which would be a
"catagory" - say III - and then a column letter using the input from
another cell, so that I can use it as the 'column number' arguement
for the Index function.