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.