We fix this array with the F4 key, so that it does not change whenthe formula is drawn. That is to say, the names of the goods and prices. The table – to select the price without the cap. It is important to put the cell number, not the word «peanut», so then you can stretch to the formula down and get the remaining valuesautomatically. The required value is the peanut from the cell B3. Write = VLOOKUP and fill in the arguments. In the cell D3 you need to pull up to the price of peanut from the right table. Manually to do this for a long time, so use the Vertical Scan function. We need to transfer the price data from the right table to the left one to calculate the cost of each batch. There is the price on the right, where the prices of each product are indicated (highlighted in blue). We have the table in which the consignments of ordered goods are registered (it is highlighted in green).
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |