Pasting Data from one sheet into a specified cell on another

[Grymm]

Hello, I'm hoping you guys can help, I've trawled various pages with no real success.
I have a very large spreadsheet, over 14k rows, I have to search for a number in column AA, on sheet 1,to find another number on the same row, reason being that I have 1 number but not the other, so I have used a Index/Match approach, but I need to be able to paste some data into a specific column on sheet 1 on the same corresponding row, from sheet 2, and I just can't find a method to do this, is there a VBA approach or any suggestions please
Thanks
Grymm

 

[Zot]

If you can provide sample sheets, you will get ultimate solution in less time. If helpers need to guess how your data looks like, then you probably be wasting time going back and forth with questions toward needed solution. . Just simple mock up sample which mimic actual sheet.

Now I know you are searching a number in column AA. Once found, need to search another number in that row but from what range? Where you wanted to paste the data to on Sheet2?