ISNA

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Fergus

Well-known Member
Joined
Mar 10, 2004
Messages
1,174
in B2 try: =IF(ISNA(VLOOKUP($A$2,July!$A:$AZ,9,FALSE)),"",VLOOKUP($A$2,July!$A:$AZ,9,FALSE)) then copy across and down

Later, you can't copy across and down, as each formula you have is specific, although by changing the $A$2 to $A2 you could at least copy down.
 

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
=If(Isna(VLOOKUP($A$2,July!$A:$AZ,9,FALSE)),"",VLOOKUP($A$2,July!$A:$AZ,9,FALSE))
 

njimack

Well-known Member
Joined
Jun 17, 2005
Messages
7,764
=IF(ISNA(VLOOKUP($A$2,July!$A:$AZ,9,FALSE)),"Not Found",VLOOKUP($A$2,July!$A:$AZ,9,FALSE))
 

Watch MrExcel Video

Forum statistics

Threads
1,114,051
Messages
5,545,724
Members
410,702
Latest member
clizama18
Top