formula to bring value from another sheet with different spaces

[veena]

i have 2 sheets in a workbook. I want Sheet 1 column A to bring in the value
from sheet 2 column D. The problem is the data on Sheet 2 in column D has 3
spaces between each sku and on sheet 1 column A the spaces between each item
to be 4 so i for example i want a formula in Sheet 1 in row1 than in row6
picking up the item from sheet 2 from row D3 and than D6 and so on.
Sheet1 Sheet2
1 1009655
2
3 1009655
4
5
6 1009685 1009685
7
8
9 1008654
10
11 1008654
thanks

 

[Therese]

Hi
Will it work if you write =Sheet2!D1 inSheet1!A1, and then copy the formular
downwards?
Therese

 

[veena]

i tried your formula but when i copy it on my sheet1 A6 it gives me zero i
dont know how to adjust the formula. Can you please help me with that.

 

[veena]

hi
i had tried that before it doesnt work due the the spaces.
thanks though

 

[David Biddulph]

The formula I gave in reply to your previous question was
=IF(MOD(ROW(),6)<>1,"",OFFSET(Sheet2!D$1,(ROW()-1)*4/6,0))

For your revised question the answer is presumably
=IF(MOD(ROW(),5)<>1,"",OFFSET(Sheet2!D$3,(ROW()-1)*3/5,0))

There isn't anything complicated in the formulae. The functions used are
IF, MOD, ROW, and OFFSET, all of which are standard Excel functions. If you
don't understand the syntax, look at Excel help for the relevant function.
It'll tell you the syntax of the function, and show examples.

 

[Therese]

Hi
Oh I see...misunderstood the question.

Therese