I am trying to insert the contents of a column from Sheet2 (VBAP in the attached) into Sheet1 (E1P). E1P may have multiples of the values in VBAP; I want the contents of the inserted column to repeat if there a mulitple values/occurrences. Right now, using the basic VLOOKUP, only the first occurrence of the 'wanted' value is returned.
