I created a table in EXCEL that I'll be entereing from day to day with data
of several organizations. two of the main columns are the "Organisation's
name" and another column for the organisation's "ID number"..... what I want
to do is to have a formula in my table so that anytime I select an
organization's Name, from a drop-down list the adjacent cell should
automatically also fill up with its corresponding ID Number....

I have created (in another sheet in the same work book) two columns sided by
side showing the ID numbers and corresponding organisation names

PLEASE HELP!! PLEASE HELP!! PLEASE HELP!!