Whether to use HLOOKUP or VLOOKUP depends on how your data is laid out
in your inventory list. I would expect you to have columns for some ID
code, Description, number available, price etc and then a list of the
items going down the sheet. If this is the case then you would use
VLOOKUP. If you can confirm your layout and the names of the sheets
involved I can provide you with a formula to do what you want.

Hope this helps.

Pete

On Sep 21, 11:04 pm, femme-a-9
wrote:
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