Nested IF formula partially not working

Hi,

New to the forum and am hoping someone can help me.

Here is my formula:

=IF(C9="House",INDEX('Detail Generator'!$H:$H,RANDBETWEEN(1,COUNTA('Detail Generator'!$H:$H)),IF(C9="Car",INDEX('Detail Generator'!$I:$I,RANDBETWEEN(1,COUNTA('Detail Generator'!$I:$I)),IF(C9="Holiday",INDEX('Detail Generator'!$J:$J,RANDBETWEEN(1,COUNTA('Detail Generator'!$J:$J)),IF(C9="Hobby",INDEX('Detail Generator'!$K:$K,RANDBETWEEN(1,COUNTA('Detail Generator'!$K:$K)),IF(C9="Emergency",INDEX('Detail Generator'!$L:$L,RANDBETWEEN(1,COUNTA('Detail Generator'!$L:$L)),"NA"))))))))))

Basically the Cell C9 is its own INDEX return and depending on what that is I want to return another index return. At the moment if C9="House" then it works but any other value I get FALSE.

Can someone see where I have gone massively wrong?

Thanks

Please share the worksheet with data

Was just trying to figure out how to upload data sheets when you replied Ace and you have fixed it! Thank you! You are a Legend!

Thank you both for you help