If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Nesting Address function within Index function
I'm trying to use a nested Address function within an Index function, but I'm
getting errors. Here's a sample of my function which is giving me an error I cannot figure out: =INDEX(address(20,1,1,true):address(30,4,1,true),1 ,2) With this function, I'm trying to get the contents of the first row, second column from an array that begins in cell A20 and ends in cell D30. I want to use the address function because I will not know the beginning and ending cell of the array. |
#2
|
|||
|
|||
mserber Wrote: I'm trying to use a nested Address function within an Index function, but I'm getting errors. Here's a sample of my function which is giving me an error I cannot figure out: =INDEX(address(20,1,1,true):address(30,4,1,true),1 ,2) With this function, I'm trying to get the contents of the first row, second column from an array that begins in cell A20 and ends in cell D30. I want to use the address function because I will not know the beginning and ending cell of the array. Is it not?... =INDEX(A2030,1,2) -- Aladin Akyurek ------------------------------------------------------------------------ Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165 View this thread: http://www.excelforum.com/showthread...hreadid=275462 |
#3
|
|||
|
|||
What do you mean when you say you will not know the beginning and ending cell
of the array? James. "mserber" wrote: I'm trying to use a nested Address function within an Index function, but I'm getting errors. Here's a sample of my function which is giving me an error I cannot figure out: =INDEX(address(20,1,1,true):address(30,4,1,true),1 ,2) With this function, I'm trying to get the contents of the first row, second column from an array that begins in cell A20 and ends in cell D30. I want to use the address function because I will not know the beginning and ending cell of the array. |
#4
|
|||
|
|||
Think you need to use INDIRECT() ..
Try something like : =INDEX(INDIRECT(ADDRESS(20,1,1,TRUE)&":"&ADDRESS(3 0,4,1,TRUE)),1,2) -- Rgds Max xl 97 --- Please respond in thread xdemechanik atyahoodotcom ---- "mserber" wrote in message ... I'm trying to use a nested Address function within an Index function, but I'm getting errors. Here's a sample of my function which is giving me an error I cannot figure out: =INDEX(address(20,1,1,true):address(30,4,1,true),1 ,2) With this function, I'm trying to get the contents of the first row, second column from an array that begins in cell A20 and ends in cell D30. I want to use the address function because I will not know the beginning and ending cell of the array. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Keeping old customer address when they move house. | Russell | General Discussion | 8 | July 19th, 2004 12:24 PM |
Function address from VB? | compound | General Discussion | 2 | July 13th, 2004 09:16 PM |
Nesting a nested function with {..} | Dave R. | Worksheet Functions | 0 | November 8th, 2003 01:09 AM |
INDEX Function | Jerzy | Worksheet Functions | 1 | October 5th, 2003 10:18 AM |