ISNA

[MarkAndrews]

For the life of me i cant figure out how to incorporate ISNA into these vlookups

Please can someone assist

Thanks

Headcountxls.xls
	B	C	D	E	F	G
1	July	August	September	October	November	December
2	67.01	67.01	68.86	#N/A	#N/A	#N/A
3	96.03	108.32	106.75	#N/A	#N/A	#N/A
4	15.14	17.14	24.86	#N/A	#N/A	#N/A
5	42.68	46.73	37.56	#N/A	#N/A	#N/A
6	55.57	76.92	66.54	#N/A	#N/A	#N/A
Sheet3

 

[Fergus]

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]

=If(Isna(VLOOKUP($A$2,July!$A:$AZ,9,FALSE)),"",VLOOKUP($A$2,July!$A:$AZ,9,FALSE))

 

[njimack]

=IF(ISNA(VLOOKUP($A$2,July!$A:$AZ,9,FALSE)),"Not Found",VLOOKUP($A$2,July!$A:$AZ,9,FALSE))

 

[MarkAndrews]

Thanks Guys!