Hello
i have data in column A of sheet 1 in some random arrangement , i have same data in column A of sheet 2 in random arrangement which is not in the same order of column A
i have data in column B and column C of sheet 2 .
Now i want to pick up data from cells in sheet 2 for example cell A5, B5, C5 & compare A5 i t with the matching data in column A
of sheet 1 & place the data of cell B5 & C5 of second sheet in the corresponding cell of F & G in sheet 1
Column A of first sheet is the index column
i cannot change the order of data in column A of first sheet or second sheet
i have data in column A of sheet 1 in some random arrangement , i have same data in column A of sheet 2 in random arrangement which is not in the same order of column A
i have data in column B and column C of sheet 2 .
Now i want to pick up data from cells in sheet 2 for example cell A5, B5, C5 & compare A5 i t with the matching data in column A
Column A of first sheet is the index column
i cannot change the order of data in column A of first sheet or second sheet