Matching two sheet datas & putting it in required cell

[ssbhatban]

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

 

[Fluff]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Sounds like you want the vlookup function How to use the Excel VLOOKUP function | Exceljet

 

[ssbhatban]

Thanks, updated I am using excel 10
I was not able to use V look up bcos i cannot sort any of the column, that is the condition
Tried index match but not able to get it right. Any other methods also will do

 

[Fluff]

Your data does not need to be sorted to use vlookup. You just set the final argument to False