I am not sure I understand you?

See the Excel help For the VLookup function
You can find a ID in your data sheet and display the values of that row in a other sheet

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"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/