auto fill multiple cell based on a non blank value

[roncoJones]

Hi,
I am trying to populate a column of cells based on another cell being non blank. The content of the cells would exist in a column on another worksheet.

for example, if A1 contains any value, cells B2:B10 would be filed in with values from a range of cells in another worksheet.

For example;
A1 = Bob
B2 = sheet2!C2
B3 = sheet2!C3
B4 = sheet2!C4
etc...

Using an IF statement i can populate one cell (B2)
=IF(A2<>"",datasource!G3)

In the above statement, the content of A2 can be anything, however B2 would contain the value of datasource!G3

how can i extend this formula to populate cells B3,B4,B5,etc...

Let me know if my question isn't clear or if more details would help.

thanks in advance.

R.