EXCEL - VLOOKUP
Enviado: 21 Jun 2018 às 07:44
Hello,
I am trying to do a VLOOK UP of info between 2 Excel worksheets and it is giving me the message as follows" " Invalid reference. This file version cannot contain formulas that reference cells beyond a worksheet size of 256 columns( column IW or higher) or 65536 rows". Bot my worksheets are much smaller than the above so why does the VLOOK UP not work I have tried the data to text format it does not work, The only way it works is if I copy and paste 1 worksheet as a " Excel 1997 to 2003" worksheet but that means a longer process. Any suggestions ?
Please help
I didn't find the right solution from the internet.
References:
http://www.excelkey.com/forum/viewtopic.php?t=910
Brand Video Production Company
Thank you
I am trying to do a VLOOK UP of info between 2 Excel worksheets and it is giving me the message as follows" " Invalid reference. This file version cannot contain formulas that reference cells beyond a worksheet size of 256 columns( column IW or higher) or 65536 rows". Bot my worksheets are much smaller than the above so why does the VLOOK UP not work I have tried the data to text format it does not work, The only way it works is if I copy and paste 1 worksheet as a " Excel 1997 to 2003" worksheet but that means a longer process. Any suggestions ?
Please help
I didn't find the right solution from the internet.
References:
http://www.excelkey.com/forum/viewtopic.php?t=910
Brand Video Production Company
Thank you