Need to Isolate Matching Numbers in Same Workbook
I hope that title makes sense. Anyway, I have one workbook that has like 220k lines and I need to see which of them contain specific numbers from a specific column, and the list of important numbers is on a different sheet. I feel like I used to do this with vlookup no problem but it doesn't seem to work anymore. Now it just returns #N/A even though I KNOW those numbers are on the sheet somewhere. Hopefully the pictures will help it make more sense.
If not I can try to explain further. I plan on returning the matching numbers to a blank column just so I can filter easily (everything that has a number, keep, everything that has an #N/A filter out) I'm sure there is a more elegant solution but I don't know what it is. Anyway thank you for your assistance I'm sure this has a simply solution as long as I explained my problem adequately
Edit: I'm sorry I've tried to add the pictures (again) to the body of the post but it keeps telling me they were deleted? And I don't understand why so I had to add them into the comments
[link] [comments]
Want to read more?
Check out the full article on the original site