I have multiple sheets in one XLS file. Some 4-character codes repeat on
different sheets. I am trying to figure out how I can reference one sheet's
4-character code to suse the same descriptor in another sheet so there is
consistency. A sample follows:

A B
Descriptor 1 AAAA
Descriptor 2 AAAB
Descriptor 3 AAAC
Descriptor 4 BBBB
Descriptor 5 BBBA

I would like to be able to put in AAAC (col B) in another sheet and have
Descriptor 3 returned to me in column A.

I want to believe this is possible, I just haven't been able to figure it out.