You should be able to do this using the Vlookup formula or a combination of
Index and Match. You would use Vlookup if the left most column in the
source table contains the product code (or it is at least to the left of the
information you want to retrieve).

Use of Vlookup is explained pretty well in Excel help.

--
Regards,
Tom Ogilvy

"Misterxpro " wrote in message
...
I have an Excel Project to do as part of my work, here is the
situation:

I need to make a commission calculator known in the workplace as
"Doshometer" I need to spreadsheet to be able to pull information from
another spreadsheet for example:

If i enter a product code i want the spreadsheet to automatically pull
the Discription, price and commission from another spreadsheet, so by
just entering the product code the main spreadsheet will automatically
fill in the rest of the information.

Sounds complicated i know but i only have six week to produce a working
Doshometer. Can you excel guru`s help me out of a hole.


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