Excel-match in col, copy some of match's data
Closed
cap1816
Posts
2
Registration date
Sunday 18 April 2010
Status
Member
Last seen
18 April 2010
-
18 Apr 2010 à 15:35
kaiyasit Posts 30 Registration date Sunday 9 August 2009 Status Member Last seen 20 April 2010 - 19 Apr 2010 à 22:50
kaiyasit Posts 30 Registration date Sunday 9 August 2009 Status Member Last seen 20 April 2010 - 19 Apr 2010 à 22:50
Related:
- Excel-match in col, copy some of match's data
- How to copy data from one excel sheet to another - Guide
- Export data from excel - Guide
- Partial match excel - Guide
- Excel mod apk for pc - Download - Spreadsheets
- How to copy data to multiple worksheets in Excel - Guide
2 responses
kaiyasit
Posts
30
Registration date
Sunday 9 August 2009
Status
Member
Last seen
20 April 2010
12
19 Apr 2010 à 22:50
19 Apr 2010 à 22:50
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