Why is this formula not working?

[Daniellel]

Hi,

Can someone please tell me why this formula is not working?

=IF(ISERROR(VLOOKUP($A2,'Hours and Headcount'!$A1:$T9999,20,$T1:$T9999),0,(VLOOKUP($A2,'Hours and Headcount'!$A1:$T9999,20,$T1:$T9999))))

 

[kidwispa]

Hi,

Can someone please tell me why this formula is not working?

=IF(ISERROR(VLOOKUP($A2,'Hours and Headcount'!$A1:$T9999,20,$T1:$T9999),0,(VLOOKUP($A2,'Hours and Headcount'!$A1:$T9999,20,$T1:$T9999))))

Hi,

Try

=IF(ISERROR(VLOOKUP($A2,'Hours and Headcount'!$A1:$T9999,20,0),0,(VLOOKUP($A2,'Hours and Headcount'!$A1:$T9999,20,0))))

 

[GlennUK]

Can you tell us why you have a fourth argument of $T1:$T9999 inside your VLOOKUPs?

 

[Sektor]

= IFERROR(VLOOKUP($A2,'Hours and Headcount'!$T1:$T9999,1;TRUE),0)

 

[Daniellel]

Hi,

Try

=IF(ISERROR(VLOOKUP($A2,'Hours and Headcount'!$A1:$T9999,20,0),0,(VLOOKUP($A2,'Hours and Headcount'!$A1:$T9999,20,0))))

No, it still doesnt like it - it is saying that the ,0, in the middle is causing the error???

 

[Daniellel]

= IFERROR(VLOOKUP($A2,'Hours and Headcount'!$T1:$T9999,1;TRUE),0)

This doesnt like the column index number?

 

[Daniellel]

Can you tell us why you have a fourth argument of $T1:$T9999 inside your VLOOKUPs?

I am not sure, i am just starting to write formulas and trying to get the hang if it!

Not really doing a good job

 

[kidwispa]

No, it still doesnt like it - it is saying that the ,0, in the middle is causing the error???

This should work...

=IF(ISERROR(VLOOKUP($A$2,'Hours and Headcount'!$A1:$T9999,20,0)),0,VLOOKUP($A$2,'Hours and Headcount'!$A1:$T9999,20,0))

 

[RoryA]

Try:
=IF(ISERROR(MATCH($A2,'Hours and Headcount'!$A1:$A9999,0)),0,INDEX('Hours and Headcount'!$T1:$T9999,MATCH($A2,'Hours and Headcount'!$A1:$A9999,0)))

 

[Daniellel]

This should work...

=IF(ISERROR(VLOOKUP($A$2,'Hours and Headcount'!$A1:$T9999,20,0)),0,VLOOKUP($A$2,'Hours and Headcount'!$A1:$T9999,20,0))

Thank you so much!

This works!!!