=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...