Need some complex formulas

[arnolju]

DATE AMOUNT CHF-USD E VENT SUCCESS - 2 SUCCESS - 2 DAY
22/09/86 1.637
23/09/86 1.6616
24/09/86 1.6575
25/09/86 1.6625
26/09/86 1.66
29/09/86 1.6425
30/09/86 1.6455
01/10/86 1.6442
02/10/86 1.6325
03/10/86 1.616
06/10/86 1.621
07/10/86 35 1.634 START
08/10/86 1.6281
09/10/86 1.6315
10/10/86 1.6192
13/10/86 1.614
14/10/86 100 1.615 END 1 1 -0.959% 1.733%
15/10/86 1.6135
16/10/86 1.6175
21/10/87 1.5025
22/10/87 1.5015
23/10/87 1.4935
26/10/87 1.46
27/10/87 1.4585
28/10/87 100 1.441 START
29/10/87 130 1.429
30/10/87 1.4285
02/11/87 60 1.42
03/11/87 1.4135
04/11/87 1.4085
05/11/87 1.3825
06/11/87 30 1.376
09/11/87 1.368
10/11/87 30 1.363 END 1 1 3.062% 6.001%

 

[Brian from Maui]

And the question is?

 

[XLGibbs]

Here is one. Not sure what you are looking for though.

=IF(ROW()-ROW($F$3)+1<=$F$1,INDEX($B$3:$B$7,MATCH("*"&LOOKUP(ROW()-ROW($F$3)+1,$D$3:$D$6,$C$3:$C$6)&"*",$B$3:$B$7,0)),""