Excel-match in col, copy some of match's data
Closed
cap1816
Posts
2
Registration date
Sunday April 18, 2010
Status
Member
Last seen
April 18, 2010
-
Apr 18, 2010 at 03:35 PM
kaiyasit Posts 30 Registration date Sunday August 9, 2009 Status Member Last seen April 20, 2010 - Apr 19, 2010 at 10:50 PM
kaiyasit Posts 30 Registration date Sunday August 9, 2009 Status Member Last seen April 20, 2010 - Apr 19, 2010 at 10:50 PM
Related:
- Excel-match in col, copy some of match's data
- Transfer data from one excel worksheet to another automatically - Guide
- Number to words in excel - Guide
- Music match jukebox - Download - Audio playback
- Tmobile data check - Guide
- Gif in excel - Guide
2 responses
kaiyasit
Posts
30
Registration date
Sunday August 9, 2009
Status
Member
Last seen
April 20, 2010
12
Apr 19, 2010 at 10:50 PM
Apr 19, 2010 at 10:50 PM
yes, use vlookup
but in Doc2 you have to move the column E to A
if not move the vlookup will be not work.
example 1
=VLOOKUP(D1,[Book4]Sheet1!$A:$B,2,0)
example 2
=IF(ISNA(VLOOKUP(D1,[Book4]Sheet1!$A:$B,2,0)),"",VLOOKUP(D1,[Book4]Sheet1!$A:$B,2,0))
This may be help you.
kaiyasit phanmakorn
but in Doc2 you have to move the column E to A
if not move the vlookup will be not work.
example 1
=VLOOKUP(D1,[Book4]Sheet1!$A:$B,2,0)
example 2
=IF(ISNA(VLOOKUP(D1,[Book4]Sheet1!$A:$B,2,0)),"",VLOOKUP(D1,[Book4]Sheet1!$A:$B,2,0))
This may be help you.
kaiyasit phanmakorn