Hi,

I have an Access database with a form that has an entry with a drop down
list attached to it. The list has two columns in it. When you select
one of the options from the list it populates one field with the first
column and another field with the second.

Is there a way in Excel to do the same thing?

I have the two columns set up as a range already, but can't get it to work.

Any suggestions?

Thanks

Keith