|
|
 |
| found 27 articles for 0.302 sec |
  |
| INDIRECT does not work with closed workbooks, so you would have to arrange
for the file CSC Volumes.xls to be open if you wanted to use it. If it was
open, then you wouldn't need the path in the formula, which would shorten it
considerably to this:
=IF(ISNA(VLOOKUP($A28,'[CSC
Volumes.xls]ppweb(Jun)'!$B$2:$BZ$13,39,FALSE)),0,(VLOOKUP($A28,'[CSC
Volumes.xls]ppweb(Jun)'!$B$2:$BZ$13,39,FALSE |
|
 |
|
 |
Group: microsoft.public.excel · Group Profile · Search for Recriter in microsoft.public.excel
Author: Pete_UK
Date: Jul 8, 2008 09:28
Can I use the =INDIRECT(ADDRESS(1,1,,,G$2)) with VLookup and ISNA? This is what my formula looks like right now. =IF(ISNA(VLOOKUP($A28,'C:\Documents and Settings\jbarton\My Documents\Excel\[CSC Volumes.xls]ppweb(Jun)'!$B$2:$BZ$13,39,FALSE)),0,(VLOOKUP($A28,'C:\Documents and Settings\jbarton\My Documents\Excel\[CSC Volumes.xls]ppweb(Jun)'!$B$2:$BZ$13,39,FALSE))) Except like i mentioned
|
| Show full article (2.27Kb) · Show article thread |
|
|
|
1 ·
2 ·
3 ·
next |
|
|
