Ok. Sometimes Excel gets funcky when you have text lists.....Excel
likes its lists in order, e.g. ascending descending....sometimes with
text lists, you have the same text string more than once in the list
and excel balks with lookup functions.

Try this.

Your going to number your products. Go to Sheet 1, and insert TWO
columns to the left of your product descriptions. Then insert the
numbers 1, 2, 3, etc. and then drag them down until every product has a
number next to it.

Lets assume your sheet now looks like this

A1 B1 C1 D1
1 Product X $100
*etc*

Then go to the column A to the left of the price list (should be empty)
and type this formula: "=A1&" -- "&B1. Copy this down to the last
product. Now highlight all of these formulas in Column A and name that
selection "dropdownlist". Now select the entire range A1:D:the bottom
right-hand corner of your list. Name that selection "bigpricelist".

Go to Sheet2. I don't know what kind of combo box you are using, but
here you want to do a simple validation list box.....

click in a cell on Sheet 2 that you want the drop-down box to be in.
Lets call it A1. Click on "Data" at the top menu. Click "Validation".
In the Allow Box, click "List." In the formula line type
"=dropdownlist". Click ok.

Now when you click in that cell you get an internal drop-down list with
all of your numbered products.

Now click in cell B1. Type "=vlookup(A1,bigpricelist,4)"

I think that will solve your problem (Excel can now see the list in
ascending order).

cheers.


---
Message posted from http://www.ExcelForum.com/