=VLOOKUP(cell_value,table,2,false) entered in cell adjacent to your
dropdown.

Sheet2 contains the table with names in column A and ID numbers in column B

e.g. sheet1 A1 has dropdown

In B1 enter =VLOOKUP(A1,Sheet2!$A$1:$B$20,2,FALSE)


Gord Dibben MS Excel MVP


On Thu, 1 Apr 2010 06:16:01 -0700, DESPERADO
wrote:

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!!