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.
Hello J_le4
Welcome to the forum.
It is better to post a dummy workbook (Atachement) so that someone may get interested to look at it.
Contributors to this forum do not get paid. They give their valuable time to help you solve your problem. That's why feel free to CLICK their STARicon to say thank you -even the given idea/solution didn't really solve your queries. The time given to you deserves a small gratitude anyway.
Dare to give a pencil to a child. http://www.blackpencilproject.org/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks