I want to display them on other sheet in a form I created (using the list
pull-down feature). Data would be:
item#, item description, UOM, Price

I want to keep all cells separate so the user can select either the edp# or
the item description. Once the user choses one or the other, all of the
corosponding data will appear.

If I pull down the menu and select item#, I want the description, UOP, Price
data to appear.

I thought there was a way to link these cells so that they stick together..?
Any ideas?