Thanks all for the Help, I got what I needed.

Cheers!

"Peo Sjoblom" wrote:

I am assuming you have a typo in the formula and Mar A should be Page A (or
if it is a translation that you missed?), however I am going to use Page A


=IF(ISNUMBER(MATCH('Page B'!A9,'Page A'!A:A,0)),INDEX('Page
A'!F:F,MATCH('Page B'!A9,'Page A'!A:A,0)),"")


should work


Regards,

Peo Sjoblom

"BJ" wrote:

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!