Making third Validation list that is dependent in column A&B (with illegal characters)

[Elainefish]

am going to make a third list (column C) which is dependent on Column A&B
it was suggested that I use =INDIRECT(SUBSTITUTE(A5&B5," ",""))
but it does not work because I am using invalid characters
I am not sure how to insert the Vlookup formula in =INDIRECT(SUBSTITUTE(B2&C2," ","")) formula

I have tried this: =INDIRECT(SUBSTITUTE(A5&vlookup(B5,NameLookup,2,false)," ",""))
but it seems that something is wrong


Really appreciate your help

[JosephP]

this appears to be another version of a question you already have posted twice?

[Elainefish]

I tried the :
=INDIRECT(SUBSTITUTE(A5&vlookup(B5,NameLookup,2,false)," ",""))
=INDIRECT(SUBSTITUTE(VLOOKUP(A5,NameLookup,2,FALSE)&VLOOKUP(B5,NameLookup,2,FALSE)," ",""))

both not working
that's why I reposted it hoping this can be resolved... just getting frustrated
third column dependent list question.xlsx

[JosephP]

if you don't reply in the same thread as the suggestion how are we supposed to know if it didn't work? it also makes it look as if you lost interest in the question

the second worked for me in your workbook-although the named range is empty in your example

[Elainefish]

Hi again,

I apologize that I reposted the same question.. I just did it hoping that there will be more people like you who will help me... Sorry for being stupid

I am not sure what I am doing wrong, but everytime I use this:
=INDIRECT(SUBSTITUTE(VLOOKUP(A5,NameLookup,2,FALSE)&VLOOKUP(B5,NameLookup,2,FALSE)," ",""))
I have a message box that says "The formula you typed contains an error
I also tried to do the renaming again of my NameLookup range but it did not worked

Can I make a special request... CAn you PLEASE you try attach my workbook with your answer... I am really clueless here.
Super Thanks

[JosephP]

here you are. you really need a database application though