Can order of columns be locked?

Can order of columns be locked?

I have several columns that link to other sheets. If the order of the columns in the inbound sheet is changed from that of the outbound sheet, the linked information ends up in the wrong column.

Is there a way to rfreeze coumn order?

Answers

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi Tanya,

    No, but there are workarounds.

    If you're using VLOOKUPs, you could replace them with a combination of INDEX/MATCH instead, and then the order won't matter.

    Make sense?

    Would that work?

    I hope that helps!

    Be safe and have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Hi Andree -

    I'm not using VLOOKUP, I am using linking. I'd like to understadn VLOOKUP and INDX?MATCHING better, but the information online is ot thorough enough for me to try it out. Do you have better VLOOKUP and INDX/MATCH instructions or sampel you can point me to?

    Tanya

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    @Tanya Brooks

    I'd be happy to share an example. 

    Please send me an email at [email protected], and I'll share it with you.

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

Sign In or Register to comment.