VLOOKUP

Julie Barbeau

Hi,

In a sheet with thousand of column, how can I know the column number so I can use it in my VLOOKUP formula?

Andrée Starå

Hi @Julie Barbeau

You could export to excel and add the numbers there. (you could even copy it to the sheet)

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

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!

John Jonassen

I tend to count as I go. You could cheat and add a Column Number row, but I don't think there is anything that provides you with the count of columns as you highlight them (as Excel does).

Andrée Starå

Hi @Julie Barbeau

You could export to excel and add the numbers there. (you could even copy it to the sheet)

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

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!

Julie Barbeau

Hi @Andrée Starå

Yes I think it's the best option :) thanks

Andrée Starå

@Julie Barbeau

Excellent!

You're more than welcome!