Current location - Training Enrollment Network - Books and materials - The correspondence between excel unit price and ISBN is in the number comparison.
The correspondence between excel unit price and ISBN is in the number comparison.
The correspondence between excel unit price and ISBN is in the number comparison worksheet. According to the relevant information of the query, in the unit price column of the order detail worksheet, the VLOOKLUP function is used to complete the automatic filling of the book unit price, and the corresponding relationship between the unit price and the book number can be known in the book number comparison worksheet.