iferror for formula

[gilnic]

Hello,
I have a longish formula that will produce an error every so often,which is to be expected. I would like to when this occurs not to have #n/a in the cell,instead to have a blank cell.
Have tried a couple of different endings but non have worked so far.
Would appreciate any guidance please.
This is the formula.
=IF(INDEX(selection!A:A,MATCH(AA6,selection!A:A,0)+1,1)="",INDEX(selection!A:A,MATCH(AA6,selection!A:A,0)-1,1),INDEX(selection!A:A,MATCH(AA6,selection!A:A,0),1))


This one doesn’t work and the one below comes up with # value in the cell.
=IFERROR(INDEX(selection!A:A,MATCH(AA6,selection!A:A,0)+1,1)="",INDEX(selection!A:A,MATCH(AA6,selection!A:A,0)-1,1),INDEX(selection!A:A,MATCH(AA6,selection!A:A,0),1,””))

=IFERROR(INDEX(selection!A:A,MATCH(AA6,selection!A:A,0)+1,1)="",INDEX(selection!A:A,MATCH(AA6,selection!A:A,0)-1,1),INDEX(selection!A:A,MATCH(AA6,selection!A:A,0),1),””)

[JeteMc]

Try this:

Please Login or Register  to view this content.

Let me know if you have any questions.

[gilnic]

Hello JeteMac,
Sorry for delay.Thank you for such a prompt response and providing a suitable solution to my query.
Thanks again.
Best wishes,
gilnic

[JeteMc]

You're Welcome, thank you for the feedback and for marking the thread 'Solved'. I hope that you have a good day.