I have two worksheets. I want to get data from Sheet1 Column E in Sheet2 Column C if data in Sheet2 Column A is the same as data in Sheet1 Column A (data from the same row).
Example:
Sheet1
A B C D E
1 d f g h
2 f g h j
3 g j k l
Sheet2
A B C
2 t
1 r
So I want in Column C Sheet 2 in first row to be "j" and in second row to be "h".
Thanks
Example:
Sheet1
A B C D E
1 d f g h
2 f g h j
3 g j k l
Sheet2
A B C
2 t
1 r
So I want in Column C Sheet 2 in first row to be "j" and in second row to be "h".
Thanks