Excel query

Closed
Sam - Jan 15, 2009 at 04:37 PM
netgear3
Posts
11
Registration date
Thursday October 16, 2008
Status
Member
Last seen
May 12, 2009
- Jan 16, 2009 at 12:43 AM
Hello,

I want to know how to copy a data from cell of one workbook to cell of another workbook which has same data in different cell?

For example

Work book one

Col A B C D
1 ID Name
2 5 sam
3 6 ram
4


Work book 2
Col A B C D
1 Name
2 ram
3 sam
4 jam


Now to be more specific which formula to use to directly paste information of id in workbook 2 from workbook 1 of respective name.

Thanks

Sam

1 reply

netgear3
Posts
11
Registration date
Thursday October 16, 2008
Status
Member
Last seen
May 12, 2009
1
Jan 16, 2009 at 12:43 AM
hi,
try this link, you will get a list of formulas used in Ms excel:

http://office.microsoft.com/en-us/excel/HP052001271033.aspx

there you can search for the formula you need.
0