I was given an Excel spreadsheet that I have to convert into a SQL view.
In the cell formulas VLOOKUP is used and for almost all of the table_arrays I can find where the table_array is. But for one particular table_array I can't find it in any of the other sheets. I also have this same problem with a variable.
Is there an function where it will just automatically bring me to the variable or table_array?