I have a list of vendor names that I wish to reference within a GETPIVOTDATA statment so that I can auto populate the correct value per vendor name i.e. the correspoding quantity is pulled from the pivot table that matches the same vendor name.