hb2474,

You need another sheet for a lookup table with all your product IDs etc.

ID Sellers ID Desc.
ht1 ab2 book
ht2 cd5 pen
.....

When your user enters the product ID, the program can then search your
lookup table for that ID and put the rest of the data in place. Take into
account miskeying of the ID number so that, if your lookup finds nothing,
you give the user the opportunity to re-enter the ID or to enter the data
manually. (This can be added to the lookup table for future reference).


HTH
Henry

"hb2474" wrote in message
...
I have a database thats like this:

units product ID Sellers product id Description
1 ht1 ab2 book


Now I want to have an input section like this


Enter product ID_______

Now when I input a product ID like ht1, I want the sells product ID to
show up (ab2) instead on another sheet

Like this:

PO#______

Seller product ID__________

Description_________

Where ab2 will show up in seller product ID.
I would also like the decription to show up also as book

This is all in one wookbook on three different sheets

Please help


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