I am using a tutorial to create a KPI gauge on a dashboard. I have listed my Raw Data and that to use for the dashboard, as shown on the tutorial. When I type =MATCH( and click the cell it does not remain in the formula when I move to my raw data. It highlights cell B3 as usual, but when I move to my other worksheet the formula then deletes B3 and changes.
this is the error that is shown
Make sure you are using a comma after you type or select cell B3, to move to the next part of the formula, i.e the look up range
Example:
=MATCH(B3,Sheet1!A1:A19,0)
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments