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(R OW(1:1),namelist,2))


--
regards,
Tom Ogilvy


"Rashid" wrote:

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),na melist,2))


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

Thansks,

Rashid