View Full Version : Solved: Offset List Help

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

need help with the following

name defined "Grabdata"


formula within worksheet


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....


Bob Phillips
04-03-2007, 08:20 AM
Explain in words how the dynamic range is arrived at, that formula makes no sense.

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

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


Bob Phillips
04-05-2007, 10:08 AM

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

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

thanks again