Dynamic Lists
 

Could someone please show me how to setup a dynamic lists that covers
multiple columns. I have used offset for one column, but I am not sure if I
can use if for 3 columns of data. I want to do this for a vlookup
application, without having to reset my list each time I add to the list
(which is frequently).

Thank you.

Dynamic Lists
 

if you look at the help index for OFFSET, you will see how it is done.

--
Don Guillett
SalesAid Software

"Alex Mackenzie" wrote in message
...
Could someone please show me how to setup a dynamic lists that covers
multiple columns. I have used offset for one column, but I am not sure if
I
can use if for 3 columns of data. I want to do this for a vlookup
application, without having to reset my list each time I add to the list
(which is frequently).

Thank you.