Hi all,
I'm having trouble with an xlookup formula for a project I'm working on. I want the lookup array to be A2 and column B but every time I try to do this it says spill error. This is the formula I've used: 'xlookup(A3 % 10 B:B, '10'! F:F, 10! B:B, "N/A).
I'm having trouble with an xlookup formula for a project I'm working on. I want the lookup array to be A2 and column B but every time I try to do this it says spill error. This is the formula I've used: 'xlookup(A3 % 10 B:B, '10'! F:F, 10! B:B, "N/A).