Formula similar to SQL ISNULL (non-macro), is there an easier way?

[Gift2women]

Without using a macro, does Excel have a better way to do the following:

=IF(LEN($A2)>0, IF(ISBLANK(INDEX('092016'!$P:$P, MATCH($A2, '092016'!$A:$A,0))), "", INDEX('092016'!$P:$P, MATCH($A2, '092016'!$A:$A,0))),"")

In SQL, for instance there is an ISNULL that only translates the value if it is NULL, does excel have that option? Something to say if the value is Blank/Null, do X, otherwise return that non-null value? Above, is a simplified version of what I sometimes have to write.
1. If A2 has a value do something: perfect
2. If the value of the INDEX-MATCH is Blank, return "": again, pretty perfect
3. If the value of the INDEX-MATCH is not Blank, return value: that value is the result of the SAME INDEX-MATCH, so I'm typing/copying the INDEX-MATCH twice per line, is there any way to do the same thing without having to return the value twice?

For SQL, lets assume I have Column1 with Row1 = 25 and Row2 = NULL;
ISNULL(Column1, 0) = 25 for Row1, and 0 for Row2 ... I only want to have to define the return once.

 

[Eric W]

I'm not entirely sure I have all the details, but you might want to try this:

=IFERROR(INDEX('092016'!$P:$P, MATCH($A2, '092016'!$A:$A,0)),"")&""

 

[Gift2women]

Perfect ... quite simplified from mine ... thank you.

 

[Eric W]

Glad to help.