Excel Macro Help
Closed
cliffshow
-
Aug 11, 2011 at 09:10 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 12, 2011 at 02:22 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 12, 2011 at 02:22 PM
Related:
- Excel Macro Help
- Spell number in excel without macro - Guide
- Macro excel download - Download - Spreadsheets
- Excel date format dd.mm.yyyy - Guide
- Excel free download - Download - Spreadsheets
- Excel marksheet - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Aug 12, 2011 at 02:22 PM
Aug 12, 2011 at 02:22 PM
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))
