Value Not Available Error - Excel 2007

[Chelrie]

=INDEX('STORE LISTING'!E:E,MATCH(A4,'STORE LISTING'!$C:$C,0))

When A has a value in it - this formula displays the correct information. However, when A is empty - it displays #N/A

I've tried

=INDEX('STORE LISTING'!E:E,MATCH(A4,'STORE LISTING'!$C:$C," "))

but that always displays an error.

I would like for the cell to show blank when no value in A column.

Any assistance is appreciated.

 

[Greg111r]

If you add an if statement to display nothing when the cell is empty this should solve your problem.

 

[xenou]

E.g.,
=IF(ISNA(MATCH(A4,'STORE LISTING'!$C:$C,0)),"",INDEX('STORE LISTING'!E:E,MATCH(A4,'STORE LISTING'!$C:$C,0)))

 

[mvptomlinson]

In Excel 2007 use the new IFERROR function.

=IFERROR(INDEX('STORE LISTING'!E:E,MATCH(A4,'STORE LISTING'!$C:$C,0)),"")