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...
1 Reply
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.
