elainefish
New Member
- Joined
- Mar 27, 2013
- Messages
- 2
I have problems making the third column (dependent on column A and B)
i tried the =INDIRECT(SUBSTITUTE(A5&B5;" ";""))
it worked, but the problem is the illegal characters
I do not know how to merge the formulas =INDIRECT(VLOOKUP(A5;NameLookup;2;0)) and =INDIRECT(SUBSTITUTE(A5&B5;" ";""))
thanks
i tried the =INDIRECT(SUBSTITUTE(A5&B5;" ";""))
it worked, but the problem is the illegal characters
I do not know how to merge the formulas =INDIRECT(VLOOKUP(A5;NameLookup;2;0)) and =INDIRECT(SUBSTITUTE(A5&B5;" ";""))
thanks
