Help please with column headings

[dave-rawlins]

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....

 

[The Code Cage Team]

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

 

[dave-rawlins]

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

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.