If you are trying to get help with Indirect, it would probably better
to give the actual references and formulas. How do your 4 digit codes
turn into a reference? Are there names already defined? What is the
actual output supposed to be in B6?

Also, if LocDescription is a Named Range, you don't need the quotes ""
in the formula.