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.
Bookmarks