Forum Discussion
Can't drag or copy XLOOKUP formula
I am using Excel online on a shared spreadsheet. I successfully created an XLOOKUP formula and want to copy it through to 550 cells below. However, if I drag down more than 5 cells I get an error mes...
If that's shared workbook with lot of different views perhaps something prevents due to another view customization.
In any case that's better to do on default (unsorted) view. Stay on the cell with formula, type in name box entire range starting from this cell
Enter - range will be selected
Ctrl+D - formula will be copied to every cell within selected range.
SergeiBaklan Thanks for the speedy reply! I'll try that now.