Xlookup but return the adjacent cell with offset?

[Waffles255]

Hi Guys,

I am trying to use the following formula : =XLOOKUP($B8,'[December 202021 WORKBOOK.xlsx]Sel'!$B:$B,'[December 202021 WORKBOOK.xlsx]Sel'!M:M) the return array being '[December 202021 WORKBOOK.xlsx]Sel'!M:M

I need it to actually return the N:N column so i can copy it across so it should skip one column on the return array to enable me to copy it across any suggestions?

Thanks in advance

 

[RoryA]

If you want it to return the N column, just change M to N, surely?

 

[Waffles255]

If you want it to return the N column, just change M to N, surely?

Hi i Kind of then have to do that over a big spreadsheet i was hoping there is a shortcut

 

[RoryA]

I don't really follow. Any change you make to a formula has to be made for any existing instance of that formula. You can use Find/Replace if there's a reliable pattern, or if you have columns/rows of the same formula, you can just edit one cell and then fill down/across as needed.