Solved: Offset List Help

[CCkfm2000]

hi all..

need help with the following

name defined "Grabdata"

[vba]=OFFSET(Data1!$B$1,MATCH(TEXT(Main!$B$15,"#"),Data1!$A$2:$B$65536,0),0,COUN TIF(Data1!$A:$A,Main!$B$15),4)[/vba]

formula within worksheet

[vba]=IF(ISERROR(INDEX(grabdata,ROW()-16,2)),"",INDEX(grabdata,ROW()-16,2))[/vba]

the spreadsheet was to big to post so i've had to cut most of the data out.

i've attached a copy of my spreadsheet


regards to all....

cckfm2000

[Bob Phillips]

Explain in words how the dynamic range is arrived at, that formula makes no sense.

[CCkfm2000]

thanks for replying back, I found the above formula on the net and modified it.

the user will enter an order number in cell B14.
B15 looks up the order number in sheet Data1.
B16 looks up the order number in sheet Data4.

I need cell B20 to B30 I need to get all the data from column B in sheet Data4

[CCkfm2000]

ok lets try this!


apart from autofilter & advance filter is there anyway of get data from a list?


i've attached an example sheet for advice.

2 sheets

1. Get List
2. Data list

thanks

[Bob Phillips]

.

[CCkfm2000]

thanks xld

will look this next week after weekend holiday here in the uk.

thanks again