[bcab] An Excel query

Hi again listers.

Tricky one.  Is it possible that anyone knows for an excel document to look up 
information when there are several looked up cells that are the same yet 
differing values may be required?  Is it possible to get excel to put a list in 
alphanumeric order by itself, ie. without sorting myself.

I have 26 cells with the same drop down list containing over 200 pieces of 
information.  These may be repeated in selected cells.  These refer to 
information cells elsewhere in the document.  The problem is to list 
corresponding data in cells next to the drop down choices section.

The big trouble is the spreadsheet.  The information cells that make up the 
drop down list are not in any particular order and thus I'm struggling to make 
the cells look up correctly and drop the information in the corresponding cells.

Cheers much

Roger

Other related posts: