I have say 10 locations coded in 4 digits; we'll call the first on "ABCD",
the second "ABCE", and a third we will call "1234". I have created a
location on a page that has the drop down list of what I call "LocCode". In
the actual spread sheet that I created the "LocCode" reference in column "A"
(cell addresses 1 - 10) I have a "LocDescription" reference in column "B"
(and also in corresponding cell addresses 1 -10).

What I am trying to do is that if on the next spread sheet (same workbook) I
drop down "LocCode" "ABCD" in cell B4; I want then the automatic input in
cell B6 to include the "LocDescription". I attempted to use:
=INDIRECT("LocDescription"&$B$4)
as the data validation with list; however this did not work and I have
attempted additional possibilities.

Any suggestions would be extremely helpful and thank you in advance!