Returning a calculated cell value? 1

[beanxx]

Simple one I hope which follows on from my previous post....

I want to return a value in cell A1 based on the value in various rows in column D as follows:-
A1 = D(((n-1)*18)+2)

where n is the value returned from a list box, such that if the list box returns 1, using the above formula I want to return the value in D2, list box returns 2, I wan the value in D20, etc.

Any ideas how I need to structure this as all I get returned is #NAME?

Thanks Justin

 

[combo]

Assuming that "n" is the name of cell, where you store the value from list box:
=INDIRECT("D"&((n-1)*18)+2))

combo

 

[beanxx]

Works a treat thanks very much and a star has been duly awarded!

Thanks,

Justin