Trying to add If condition....

[ZachNeff]

Ok so I have this working formula:

=IFERROR(INDEX(Sheet3!AF:AF,(MATCH(B4,Sheet3!A:A,0)+1)),(""))

and I am trying to add in an IF condition something like this:

=IFERROR(IF(Sheet1!A6>=3,(INDEX(Sheet3!AF:AF,(MATCH(B4,Sheet3!A:A,0)+1)),(""))))

I can't seem to get the syntax right....

Any help would be greatly appreciated!

Thanks!

[kvsrinivasamurthy]

Try this

Please Login or Register  to view this content.

[RobertMika]

Maybe
=IF(Sheet1!A6>=3,IFERROR(INDEX(Sheet3!AF:AF,MATCH(B4,Sheet3!A:A,0)+1),""),"")

[ZachNeff]

Thanks Robert, That did the trick!


It was making me crazy!