Can order of columns be locked?

Tanya Brooks

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?

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!

Tanya Brooks

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å

@Tanya Brooks

I'd be happy to share an example. 

Please send me an email at andree@workbold.com, and I'll share it with you.