Can I use if statements within Index Match

[kluna90]

Hi, I need help with my formula here in the director column.. Essentially what I'm trying to do is combine multiple tables together using the show_id. If there is show_id missing from the directors table it's reflecting as #NA in my Index Match formula. So what I would like to do further with this formula is to include in the formula an if statement that says if the director is "#NA" then "None". How can I do this within the statement? Can I add it to the Index Match formula? I appreciate the help

 

[ravi2628]

Hi, I need help with my formula here in the director column.. Essentially what I'm trying to do is combine multiple tables together using the show_id. If there is show_id missing from the directors table it's reflecting as #NA in my Index Match formula. So what I would like to do further with this formula is to include in the formula an if statement that says if the director is "#NA" then "None". How can I do this within the statement? Can I add it to the Index Match formula? I appreciate the help

View attachment 47414
View attachment 47415

Use Iferror function before the index

=iferror(your formula,"None")

 

[kluna90]

That worked - Thank you so much!

 

[ravi2628]

That worked - Thank you so much!

You are Welcome