Here's what I want to do:

This is for a record of sales. Each time a sale is made, next to the
invoice number and all of that I want to have a pull-down box where I can
choose from my Inventory List and pick which item was sold. That's my first
problem. I can't seem to get the "Pick From Drop-down List" feature to work
with my already populated list.

Second problem is that if I ever get it to where I can select from the list
which item has been sold, I want the very next cell to automatically pull the
wholesale cost from the inventory list.

I thought I had a clever IF THEN formula written which would have absolutely
worked except for the limit on the number of nested formulas.

I don't quite get the explanation in the Help section for HLOOKUP & all
that. Can anyone make it simple for me? I know I could do this in about 5
seconds in Access but unfortunately I don't have it.

Thanks to anyone who helps!!!

Brenna