VLOOKUP not allowing me to return value from beyond Column #20

Jrlopez210

Hello - I'm using VLOOKUP to return values from two separate data sets based on a unique identifier for my projects.  For one of the VLOOKUPs, the column_num (column that I want to return the value from) is column 27.  Why is it that VLOOKUP will return any value from columns 20 and below only?

Andrée Starå

Hi,

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD