Making the third validation list (dependent on colum A&B) with illegal characters
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
| Attachment | Size |
|---|---|
| question third.xlsx | 34.47 KB |
Named ranges
Try to use named ranges instead of cell references.