Dynamic Range

[Rashid]

Hi All,

I have the following two dynamic ranges

=OFFSET(PBR!$A$1,0,0,COUNTA(PBR!$A:$A),1)
=OFFSET(PBR!$A$1,0,0,COUNTA(PBR!$A:$A),2)
Note: there will be two ranges
namecount & namelist

The formula which would be using the above range is
=IF(MAX(namecount)<ROW(1:1),"",VLOOKUP(ROW(1:1),namelist,2))


Big question!!!, can I join these ranges together in to one statement.
if so than how ???

Thansks,

Rashid

 

[Bob Phillips]

=IF(MAX(INDEX(namelist,,1))<ROW(1:1),"",VLOOKUP(ROW(1:1),namelist,2))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Tom Ogilvy]

What do you mean by combine. The first range is the first column of the
second range.

If you only want to use one range, you can do
=IF(MAX(Index(nameList,0,1))<ROW(1:1),"",VLOOKUP(ROW(1:1),namelist,2))