Hello all,
I have used vlookup for exact matches before, but now I have data where I need my results to show me all matches. All data has a 9 digit code and I need the data from the 4th column. When I use vlookup I am only getting the first exact match. What/How do I get excel to dislplay all exact matches from my data. I am looking up 20 specific items in a 2000+ line spreadsheet with the several exact matches per item I am looking up. I want to list the entire row of data each time I find the specific code(ID). I can use the auto filter to view the data for each specific code(id) then copy the rows manually. How can I automate this process. Any and all assistance will be greatly appreciated.
Thanks, Steve
I have used vlookup for exact matches before, but now I have data where I need my results to show me all matches. All data has a 9 digit code and I need the data from the 4th column. When I use vlookup I am only getting the first exact match. What/How do I get excel to dislplay all exact matches from my data. I am looking up 20 specific items in a 2000+ line spreadsheet with the several exact matches per item I am looking up. I want to list the entire row of data each time I find the specific code(ID). I can use the auto filter to view the data for each specific code(id) then copy the rows manually. How can I automate this process. Any and all assistance will be greatly appreciated.
Thanks, Steve