Help, Cannot Get Rid of #N/A when using Index, Match - Have looked at prev posts & no luck

[darkmagikmatt]

Hello All,

I am a novice intermediate excel user, I have made a referencing worksheet but cannot for the life of me get rid of these #N/A when the formula doesn't return a result. The thing is on my sheet all of my searches will bring back at least 1 #N/A

please help me and asap if anyone can, i am online now and will try it.

my formula is:

=INDEX('Pub Company List'!D:D,MATCH('Site Details'!C4,'Pub Company List'!C:C,0))

Cheers,

Matt

[Jonmo1]

Try

=IFERROR(INDEX('Pub Company List'!D:D,MATCH('Site Details'!C4,'Pub Company List'!C:C,0)),"")

[darkmagikmatt]

Try

=IFERROR(INDEX('Pub Company List'!D:D,MATCH('Site Details'!C4,'Pub Company List'!C:C,0)),"")

Perfect, Thank you so much. Every other post i looked at didn't break it down like that, genius. I love this forum, it took 4 minutes to find the answer.

[Jonmo1]

You're welcome.