Thread: Data consolidation between two worksheets

I’m attempting to merge two sets of data together. The full sets contain tens of thousands of rows of data. I thought there might be a way using a common field to merge the data? I’ve been googling but not finding anything that quite fits what I’d like to do. I’ve attached a sample of what I’m working with:

In sheet 1 you should see the common field highlighted (column M) the same on sheet 2 (Column A). What I’d like to do is whenever there is a match between those two numbers is bring the data in column E (highlighted in red on Sheet 2) into Sheet 1.

The data in Sheet 2 will be enormous and have many, many numbers in Column A that won’t match anything in Sheet 1. Sheet 1 basically has most of the data I need apart from the all important “occup” data in Column E in Sheet 2.

Thanks in advance for any assistance you might provide,

Thank you both, it seems to be running now and pulling in the data.

Originally Posted by protonLeah

If both sheets are sorted by inci_no, you should be able to use VLOOKUP.

Could I use VLOOKUP to move text in the same way that I've been using SUMIF to move numbers? I've another table, same setup only I need to move text when I get a match.

Thanks,