Current location - Health Preservation Learning Network - Healthy weight loss - How to express the formula in EXCEL with VB?
How to express the formula in EXCEL with VB?
In VB, you can use the following code to express this formula:

```

Range ("B3"). Formula = "= if (a3 = "","",index (classification! D, match (C3, classification! E:E,0)))”

```

This code will enter this formula into cell B3. If you want to use this formula in other cells, just replace "B3" in the code with the cell where you want to enter the formula.