Average the last value from up to 8 possible subsets

[Lupp]

See also tdf#167468

[koyotak]

@Lupp

I used LOOKUP() very rarely

I learned far too late that the three LOCKUP functions were specifically designed for numbers and digits, while I was misusing them for TEXT and characters, which was all too often incorrect. Now I deal with them playfully.