Good point, Gord: 2 range names (items only and items with prices)...not just
1.
I thought it, but didn't type it. I hate it when that happens!

€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢
Regards,
Ron


"Gord Dibben" wrote:

SDEEM

Place your ITEMS and PRICES in two adjacent columns on Sheet2.

Select the ITEMS range and InsertNameDefine.

Name it Itemslist.

Select ITEMS and PRICES range together and give that a name.

Name it LookTable

Select Sheet1 A1 and DataValidationListrefers to =Itemslist

In B1 on Sheet1 enter this formula =VLOOKUP(A1,LookTable,2,false)

Pick an item from the drop-down to get a price in B1


Gord Dibben Excel MVP

On Wed, 16 Nov 2005 15:57:04 -0800, SDEEEM
wrote:

I'm trying to create simple program for my little shop sales. I listed all
sale ITEMS and their PRICES in two columns table. I created a drop down list
for the column of ITEMS and what I want exactly is the following:

When I select the ITEM from the drop down list I want to see the price of
the item displayed in the adjacent column.

I know this feature is available in access but I'm not good enough in access.

Regards