Extracting data

Joined
Nov 19, 2005
Messages
3
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top