this is a stupid question i know, but please help. i have 2 columns
containing corresponding data, i.e. cell a6 contains the item i sell, cell b6
the price of that item. i have 148 different items, with 148 corresponding
prices - in cells a6 through a154, corresponding with cells b6..b154. i want
to create a drop down list in, say column d, where the contents of column a
is displayed via the drop down list in each of the cells in my list in column
d (cells a6..a148). what i then want is when i select, say the "doorbell",
in the dropdown list of my cell d12 in column d that the price of the
doorbell is automatically displayed next to d12 in e12. how do i do it?
thanks.