Brianwarnock
Retired
- Local time
- Today, 10:38
- Joined
- Jun 2, 2003
- Messages
- 12,701
Assuming apple is just flowery decoration and if's are irellevant and that the values are okay then :- (see attached for example =INDIRECT("Sheet1!A"&ROW()*4-3))
Alternatively I could do it with an array but that would slow your spreadsheet down ... alot ...
I think apple meant apply and I don't see why the ifs are irrelevent.
Brian