Help please with column headings

  • Thread starter Thread starter dave-rawlins
  • Start date Start date
D

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....
 
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
Click to expand...

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