知乎，让每一次点击都充满意义 —— 欢迎来到知乎，发现问题背后的世界。 Use ARRAYFORMULA to conduct calculations on arrays of dat It’s beneficial for implementing a components to a whole column or row at the same time, cutting down the need for duplicate-pasting formulation. Use XLOOKUP when You will need a more flexible lookup function which will look for https://us.hc6.org/