Look in another sheet match & bring data back

I have tons of data, this is why im trying to do this formula, or else id do it manually with the formula I have. Basically I need to match data in Plan 2. So it would take column K5, and column in plan1, E5 (any in E5) and if it doesnt match it would, skip that cell and go down until the match data is found. Once its found it would copy cells I, N, O, P Q.

***I could do with this, but if anyone can help me adjust, but I would like if possible, is some direciton if I wanted it to look at Plan 2 K5 AND, plan 2 J5 (but J5 it needs only to contain) and K5 will match. Then it would go to Plan 1 and look in rows E Going down for anything that matches plan2K5 and matches anything from plan2J5 in rows D. Then copy the cells, Once its found it would copy cells I, N, O, P Q.
**if this is to extreme id be happy with some help with the first one.


I have tried about 5 different programs, this one seems to be the closest, the other one I did is a loop, but it just loops every other cell, doesnt help much, but Ive saved it in the excel sheet. Heres the one i think can work: Im going to keep messing with the formulas, but any direction, thanks!!

Please Login or Register  to view this content.

*starting to work a lot better*

This program below I did is working a lot better, but I need some additional direction. This program, need to run it in Plan1, iwill find anything named "TANQUES" and copy the offset cell I call and paste it. This is great, but I want to take it another step further, see if anyone can help.

I want to be able to: In Plan2, look at K5, and then go to Plan1, search for the name, and when it finds it, copy and paste the offset cell I have below, and bring it back to Plan2, and paste it in the blank cell, for this instance, in Plan2, the blank cell in the column would be AE5.
Then it would go to the next cell Plan2K6 and then go back to Plan1 search for the name.. comeback and post it into AE6...

I think this program below is close, would need some tweeking, just seeing if anyone could give me some additional advice...

Please Login or Register  to view this content.

IM GOING to keep working on this one, but any direction, appreciate it, even a little hint, goes a long way, I think im almost there!, thanks

Please edit your posts & use Code Tags, not Quote Tags