Forum Discussion
VLookup formula error only in Excel 2016 not 2019
I have a new SQL administrator who is recreating a customer database to work with our custom building software. In so doing she is using VLOOKUP heavily in the excel spreadsheet. The problem comes in...
The parenthesis seems to have been eaten in posting, yes.
The values are being pulled from a separate table in another tab of the file.
How do I check to see if that has been changed to range?
The values are being pulled from a separate table in another tab of the file.
How do I check to see if that has been changed to range?
I recommend watching the video. Knowing how to work with tables is not difficult and makes all the difference in what you can achieve with Excel.
If the formula is on a table when you click on the cell a new tab called "Table Design" at the top of your ribbon should appear. That tab does not appear when you are using a range and not a table.