Forum Discussion
VLOOKUP character map
Is there some sort of character map for vlookup functions? I have a suggested function that contains an '!' and I can't seem to find anything on what that's for...
The exclamation mark gets used in referring (in VLOOKUP or any other formula or function) to another tab. For example, this is part of a formula in one of my workbooks, referring to the first sheet in another workbook: Worksheet1!$A$5:$T$100 Notice the exclamation mark just before the range references and after the tab's name.
or here's another one =FILTER(INDIRECT(Tables!P1)) referring to a single cell in another tab, nested within two functions. The exclamation mark essentially marks off what precedes it as the name of a tab or sheet....
Hope that helps.