It is optional, and we wanted the default of an exact match. In this formula, the fourth and fifth argument were ignored. We are interested in using the “Search last-to-first” option. The sixth argument of the XLOOKUP function provides four options. We want to return the stock level from the last time it was checked (last occurrence of the Product ID).
0 Comments
|
AuthorJesse ArchivesCategories |