Remove #N/A if index(match()) does not return value

[bloodybrit90]

Hi Guys,

When the following formula does not have a value it returns #N/A. How can I get excel not to display the #N/A? Maybe an if statement. I tried if formula is true return formual....but excel wouldnt move onto the false portion when i typed a comma. Any Ideas?

{=INDEX(Inputs!$G$31:$G$39,MATCH(Summary!D39,Inputs!$C$31:$C$39&" "&"Bedroom"&" "&Inputs!$B$31:$B$39,0))}

 

[Aladin Akyurek]

@Liam2003

You are welcome. Thanks for the kind words.