VSCELL function

VSCELL is the function that allows you to reference data contained in other cells in this spreadsheet. (1) and (2) are elements of the function, which means that in the place where you put (1), you take the data from the first cell that you refer to in this function. 
In this case, we use the function VSCELL, then we have a prefix for the home team *, and then we need the player's number, which is in cell H4, so we put (1) before the R and then after coma, we will put H4 as the first cell that we will refer to. Then we need the reception zone, which is in cell H5, so we put (2) after the reception, and as the second cell, we put H5. That's why we have the following:
VSCELL("*(1)R(2)0;B-0",H4,H5)
This VSCELL function allows us to change our data by simply changing the numbers in the cells we refer to instead of changing the whole function whenever we want to analyze a different zone or player.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article