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
- Music match jukebox - Download - Audio playback
- How to copy data from one excel sheet to another - Guide
- Partial match excel - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Tmobile data check - 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