Consider only first matching and copy Row

I need a formula in Sheet3 A1 that If A1 of Sheet1 is equal to any Cell of column A of Sheet2 than that Row should be copied to Row 1 of sheet3 and if A1 of Sheet1 matches to more than one cell of column A of Sheet2 than it should consider the first matching and should not take notice of other matching

e.g If A1 of sheet1 matches A1540 of Sheet2 than all filled up Cells of Sheet 2 Row A1 should be copied to Sheet3 Row A1 and if it matches with e.g Sheet2 A1900 and A2600 than it should not take notice of that. It should take only first matching that is A1540.

And I want to copy down the formula.

Sheet3, A1:

Formula:

=VLOOKUP(Sheet1!$A1,Sheet2!$A$1:$Xx$Xx,COLUMN(B1)-1,0)

Change $A$1:$Xx$Xx to accommodate your full range of cells, then copy right and down as far as needed.

Thanks daffodil11, but I am a novice. Please let me know the exact formula. I have A1 To A15000 in sheet1 but A1 to A90000 in sheet2 and sheet 2 total filled up columns are up to column G.

The exact formula you put in A1 of Sheet3 is this:

=VLOOKUP(Sheet1!$A1,Sheet2!$A$1:$G$90000,COLUMN(B1)-1,0)

Once it is entered, you copy and paste it out to column G, and down to row 15000.

it is showing the matches. But two things are not happening. First instead of deleting the unmatched rows, the unmatched cell of Column A are showing #NA. Second the rest of column upto G are coming blank. And what is the meaning of paste it out to column G. Does this mean the same formula to enter in all the columns upto G.

Yes, the formula in A will be copied and pasted to all the other cells. Only certain parts of the range have absolute references, so the formula will adapt as you move it around.

The same formula used in A1 copied into C5 will say:

=VLOOKUP(Sheet1!$A5,Sheet2!$A$1:$G$90000,COLUMN(D5)-1,0)

and it will pull the value of Sheet1!A5, and pull the corresponding data from the 4th column over on Sheet2.