1. First, organize the data in the left to right format because the function works in this order. Such an arrangement (shown in the next image) makes it easy to use the VLOOKUP function. 2. Place the cursor where the formula is to be entered. For example, since the trouser price is to be found, we place the cursor in cell F2, as shown in the ... 3. In the following pointers (steps 3a to 3d), all the arguments of the VLOOKUP function concerning the current example are explained one by one. Step 3(a ...
確定！ 回上一頁
