Matching data from 2 columns+

[coasterreal]

The + means theres more.

Heres the breakdown.

I have data in A4-C4 (top to 200 rows of it). This needs to stay together. Its yesterdays data.

I then get new data that will go in F4-H4 (up to 200 rows). This is new data.


I will take what is in A4 and search it against everything in F. If it matches, I need it to copy A4-C4 to a new set of cells. If it does not, nothing is copied.

Ill just copy it down to around 200 since well never have that much data. I will then use it as a template so we need to do is input the data and the formula spits out the matches with the cells next to it.

Right now I can can A4 and match it against the data in F and copy what is in A4. But I still need to manually copy the data in the cells next to it (B4 and C4) over. Id like those to somehow be "attached" to A4.


Thanks in advance. Im pretty much a n00b but Im a fast learner and I love to learn new things, so bring it on.

 

[coasterreal]

Actually, I need to reverse that. Well take the Cell F4, match it against everything in A and if matches, copy over A4-C4 to a new set of cells.

Then Id copy it down so that F5 would be matched against everything in A and if it matches, copy over A5-C5. And so on down the rows.

I just realized after looking I needed to reverse it to get the proper results. This is the correct way I am looking for.