use only 1 specific column from named range

**Decar** · 11-28-2013, 12:22 PM

Hi,

I'm using dynamic named ranges a lot recently. One thing that bothers me is that I have to do so many for one range.

For example I have a named range from A1:G30. Now I can use this named_range to do vlookup etc. but when I for example want to use the match with the index function I have to define a new range because for the match function to use it need only one column or row. Is there some hidden command I could use like named_range_row1 ? This would make it so much easier to read the code and I dont have to construct so many named_ranges.

**martindwilson** · 11-28-2013, 12:43 PM

with your named range as say myrange
=MATCH(H1,INDEX(myrange,,3),0) would lookup in col 3 of that range

**newdoverman** · 11-28-2013, 12:54 PM

Can you post a sample of what you are doing? There are a lot of things that you can do with ranges and it is difficult to give you an answer without knowing what it is that you are doing.

**Decar** · 11-28-2013, 02:05 PM

Thank you Martin it works!

NewDoverman you are right its quite a lot I "could" do if I would be a bit better with some formulas. Know this part works but I cant connect it to another sheet...

I opened a seperate thread for that.

Thank you so much for your help guys!

http://www.excelforum.com/excel-gene...ml#post3493117