Performance affect of "SELECT:" and "LOOKUP:" used together
I couldn't find any information on whether it's recommended to split SELECT and LOOKUP for better performance. This thread helped me to understand that SELECT works in a similar way as LOOKUP (thanks to @DavidSmith for insight). So does it mean that SELECT and LOOKUP can be used together, unlike SELECT and SUM?
And what is the overall performance affect of SELECT compared to LOOKUP? Should it be avoided if possible? Or it has almost no affect on calculation time?