A deflected strike by Jack Owen in the 95th minute put Lundwood into the Challenge Cup final at Oakwell with a 4-3 win and broke the hearts of Royal Albert, who had led 3-0.
Premier League champions Lundwood were strong favourites going into Tuesday's semi-final but were stunned to concede three goals to the Division One side in the first 20 minutes at Athersley Rec's Sheerien Park. Good finishes from Jake Jackson and Ben Lang either side of a bad error from Lundwood goalkeeper Jamie Oddy from Ryan Keen's 60-yard free-kick made it 3-0.
Ben Pearson and Zack Lycett made it 3-2 after 36 minutes then Ryan Jennings headed in for 3-3 on 89 minutes before substitute Owen won it.
Lundwood are through to the final at Oakwell in May in which they will face Wombwell Main, who cruised through with a 4-0 win over Worsbrough Common in a much more one-sided first semi, also at Sheerien Park. Jason Bentley bagged a brace while Martin Watkin and Matt Tonks also netted.
Wombwell then thrashed Doncaster side Toll Bar 5-0 on Sunday to make the quarter-final of the Sheffield Sunday Senior Cup. Danny Frost hit a hat-trick while Mark Hume and Joe Ashurst struck.
In the Northern Counties East League, Athersley Recreation played their first game for exactly a month and drew 2-2 at Premier League leaders Tadcaster Albion.
In Division One, Craig Elliott won his first two matches as Shaw Lane Aquaforce boss as they beat bottom club Louth Town 3-1 on Saturday then crushed mid-table visitors Teversal 7-2 on Tuesday night to move two points behind second-placed Cleethorpes and five adrift of leaders Bottesford.
In the County Senior League, Penistone Church and Houghton Main warmed up for their crucial Barnsley derby tomorrow with 4-0 home wins on Saturday in the Premier League.
Church cruised to victory over fellow town side Wombwell, who are second bottom, as Scott Briggs, Lewis Dickinson and Mitch Savage made it 3-0 on 33 minutes then Ross Walker completed the rout in the second half. They are now 11 points behind leaders Oughtibridge, who did not play, with two games in hand. Two goals from Nicky Harper inspired fifth-placed Houghton to a 4-0 win over fourth placed Swallownest MW.