Forum Discussion
formulas
I'm trying to use the XLOOKUP formula and when trying I can use the 1 cell reference but can't use the whole column without excel popping up an error message about there being a problem with my formu...
I'm trying to use the XLOOKUP formula
Viewing your formula help us to help you.
can't use the whole column without excel popping up an error message about there being a problem with my formula
Be careful: the 2nd and 2rd parameters must be the same dimension; if you use the entire column as the search range, the return column must be an entire column and vice versa.
Please post your attempt so that the correct solution can be suggested.
Bye