ISNA/Vlookup function

[Nlneff]

Hi, I'm using the following worksheet forumula in excel.

IF(J25<0,VLOOKUP(C25,Sheet2!A12:I62,2,0),(VLOOKUP(C25,'M:\USBPSReports\LER
Portfolio\May 2004\[565 Master Lease - Ma
04.xls]Sheet1'!$B$8:$R$348,9,)))

This usually gives a N/A when the lookup for the first functio
(C25,Sheet2!A12:I62,2,0) doesnt produce anything. Is there a way t
use ISNA to give the result for the secon
function,(VLOOKUP(C25,'M:\USBPSReports\LERT Portfolio\May 2004\[56
Master Lease - May 04.xls]Sheet1'!$B$8:$R$348,9,) if the result of th
first one is NA?

Thanks in advance

 

[Juan Sanchez]

Some formula eh!!


=IF(J25<0,IF(ISERROR(VLOOKUP(C25,Sheet2!
A12:I62,2,0)),VLOOKUP(C25,'M:\USBPSReports\LERT
Portfolio\May 2004\[565 Master Lease - May 04.xls]Sheet1'!
$B$8:$R$348,9,),VLOOKUP(C25,Sheet2!A12:I62,2,0)),VLOOKUP
(C25,'M:\USBPSReports\LERT Portfolio\May 2004\[565 Master
Lease - May 04.xls]Sheet1'!$B$8:$R$348,9,))

This will check if J25 less than 0, if so do the firts
lookup, if this yields an error do the second, if j25 not
less than 0 it will go directly to the second...

Cheers
Juan

 

[Nlneff]

Thanks, I'll see if it works!

Nathan