Forum Discussion
Duplicate value for lookup
I have a set of data with the stock number and its' specification and another set of data with the order and the requested specification, is there a way to use excel to automatically match the stock ...
Hi marcolo2012! I have a solution for you. In my suggestion you need two auxiliary columns, but you can hide them in a separate worksheet or otherwise. I have included a sample document so that it will work in your regional Excel environment. If you can't use XLOOKUP() yet, I have suggested two alternatives. I hope the solution meets your expectations. Otherwise please contact me again.