By finding the sheet name using an Excel formula it ensures that if the sheet name is changed the formula returns the new sheet name. When we use a reference to a cell on the current sheet we just type in the name or select it using the mouse. The FIND function is case sensitive.
For example in a workbook with Sheet1 Sheet2 and Sheet3 running left to right the following formula will return 2.
Getting data from another sheet using HLOOKUP Function. In the screen shot below this formula. When we want to refer to a cell in a different sheet in the same file we preface it with the name of the sheet and an exclamation mark. The FIND function is a built-in function in Excel that is categorized as a StringText Function.