Excel Reference Sheet Name In Formula - In this example, the goal is to create a lookup. Web in this article, we saw three different formulas that you can use to reference a tab name in your worksheet. Web = vlookup ( val, indirect (' & sheet & '! & range), col,0) explanation. Type the following formula in cell c4.
In this example, the goal is to create a lookup. Web = vlookup ( val, indirect (' & sheet & '! & range), col,0) explanation. Web in this article, we saw three different formulas that you can use to reference a tab name in your worksheet. Type the following formula in cell c4.