I'm having trouble grabbing data with a vlookup without duplicating data results. My data sheet has 2 columns: Column 1 has a # either 1,2, or 3 that is assigned to independent data labels in column 2. My data has about approx. 50 rows with 1, 2, or 3 assigned to mulltiple rows. I'm trying to do a vlookup that grabs all the results for one number (2) and provide the data label in column 2. The first result works, but when I copy the formula down my results column I get duplicate results because I believe there are blank rows in my data that I have to leave.
Does anyone have a solution? If further clarification is need let me know. Thank you in advance.
Bookmarks