Formulas

  • Thread starter Thread starter B.G. - Canada
  • Start date Start date
B

B.G. - Canada

I want to enter the formula =IF(Data!D18="","",Data!D18). Is there any way to
have the fomula automaticaly capture the reference Data in the next cells
without manually typing it in as the Data is not consecutive. Example below

=Data!A18 =Data!B18 =Data!C18 =Data!D18
=Data!A20 =Data!B20 =Data!C20 =Data!D20
=Data!A22 =Data!B22 =Data!C22 =Data!D22
=Data!A24 =Data!B24 =Data!C24 =Data!D24
=Data!A26 =Data!B26 =Data!C26 =Data!D26
=Data!A28 =Data!B28 =Data!C28 =Data!D28
=Data!A30 =Data!B30 =Data!C30 =Data!D30
=Data!A47 =Data!B47 =Data!C47 =Data!D47
=Data!A49 =Data!B49 =Data!C49 =Data!D49
=Data!A51 =Data!B51 =Data!C51 =Data!D51
=Data!A53 =Data!B53 =Data!C53 =Data!D53

Any Help would be greatly appreciated!
 
Put the row numbers in column E from E1 to E11:

18
20
22
24
26
28
30
47
49
51
53

Then put this formula in A1:

=IF(INDEX(Data!A:A,$E1)="","",INDEX(Data!A:A,$E1))

and copy across to D1. Then copy A1:D1 down to row 11.

Hope this helps.

Pete
 
Back
Top