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/