Hi, I would really appreciate if someone helped me with vlookup limitation. I work with part numbers and more than often the same part # appears several times in the column with several different corresponding values in the column to the right of it. It seems to be a common problem that vlookup only returns the corresponding value for the 1st match only, while ignoring other matches of that same part number down the column. Is there a solution that would return all of the matches at once?