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

--
HTH

Bob Phillips

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

"Rashid" wrote in message
oups.com...
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