Hi all,
was wondering if you could help me, I am trying to do the following:

I've linked a dropdown box to a table with over 4000 entries in it and
need to selectevly bring up a text value from that table, for example:

The drop down menue contains:

Apple
Orange
Pear

then apple selected I need "Apple" and the text attached to the other
cell to pop up sa "ABC123" for Apple ABC124 for Orange and ABC125 for
Pear.

Hope this makes sense.

Thanks,
Stan