PDA

View Full Version : Solved: Offset List Help

CCkfm2000
04-03-2007, 08:07 AM
hi all..

need help with the following

name defined "Grabdata"

=OFFSET(Data1!\$B\$1,MATCH(TEXT(Main!\$B\$15,"#"),Data1!\$A\$2:\$B\$65536,0),0,COUNTIF(Data1!\$A:\$A,Main!\$B\$15),4)

formula within worksheet

=IF(ISERROR(INDEX(grabdata,ROW()-16,2)),"",INDEX(grabdata,ROW()-16,2))

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
04-03-2007, 08:20 AM
Explain in words how the dynamic range is arrived at, that formula makes no sense.

CCkfm2000
04-03-2007, 08:46 AM
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
04-05-2007, 09:06 AM
ok lets try this! :banghead:

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
04-05-2007, 10:08 AM
.

CCkfm2000
04-05-2007, 10:24 AM
thanks xld

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

thanks again