Try instead in this form:

=IF(ISNA(MATCH(...)),"",INDEX(.. MATCH(...)))

Error trap for the MATCH(...) part will do
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
BJ wrote in message
...
Hello,

I am using the following function =IF(INDEX('Page A'!F:F,MATCH('Page
B'!A9,'Mar A'!A:A,0))=#N/A,"",INDEX('Page A'!F:F,MATCH('Page B'!A9,'Page
A'!A:A,0))) and it keeps returning a #N/A when the MATCH() function errors
out, but what I want to show is "" (blank space). Obviously there is
something wrong with my formula but I can't figure it out. If anyone out
there can help me please let me know what I am doing wrong

Thanks!