Hi!

One way:

Select the range M1:S1250

Enter this formula in the formula bar as an array using the key combo of
CTRL,SHIFT,ENTER:

=INDIRECT(A1&"!A1:G1250")

Biff

"TUNGANA KURMA RAJU" wrote in
message ...
I am looking for a formula --- to lookup a value from A1(which has a
datavalidation list of sheetnames inthe w/book) and extract data from that
sheet range A1:G1250 to current sheet. example A1=Smith
formula I want in M1=Smith!A1:G1250
If I drag fill handle of M1 all data should come to M1:S1250 range.