Sort & Filter
An xlookup will produce a single result based on a criteria. A Filter can do the same but produce multiple results. Below I produce all results for vendor code "coosto"
Then, I used the sort function to order it from smallest to largest.
Comments
Post a Comment