Excel Macro Help
Closed
cliffshow
-
11 Aug 2011 à 21:10
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 12 Aug 2011 à 14:22
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 12 Aug 2011 à 14:22
Related:
- Excel Macro Help
- Excel mod apk for pc - Download - Spreadsheets
- Excel online macros - Guide
- Vat calculation excel - Guide
- Kernel for excel repair - Download - Backup and recovery
- Excel run macro on open - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
12 Aug 2011 à 14:22
12 Aug 2011 à 14:22
But which column set of other sheet ?
You can use vlookup too if you want
Some thing like this
=IF(ISERROR(MATCH(A12,'C:\Documents and Settings\test\Desktop\[12.xls]12'!$B:$B,0)),"",VLOOKUP(A12,'C:\Documents and Settings\test\Desktop\[12.xls]12'!$B:$D,2,FALSE))
You can use vlookup too if you want
Some thing like this
=IF(ISERROR(MATCH(A12,'C:\Documents and Settings\test\Desktop\[12.xls]12'!$B:$B,0)),"",VLOOKUP(A12,'C:\Documents and Settings\test\Desktop\[12.xls]12'!$B:$D,2,FALSE))
