formula to look up the ID # in one worksheet and return all records from another

[ReneeK]

hi there


I am after a formula that will look up the customer ID number in cell B1 of a worksheet, and return all records for that ID number which held in the master spread sheet


the ID number is a supplier number and i want to enter the supplier number into the cell B1 and for the formula to return all the transactions for that supplier


it will need to return nine columns of information:


Supplier ID Number - Supplier Name - Search Key - Item - Description - Unit - Item - Item part2 - Unique


the master file has over 100,000 transactions and 900 suppliers, so in the new worksheet i just want the transactions for the supplier number specified in cell B1


Can any one help


thanks

renee

 

[SirJB7]

Hi, ReneeK!


Give a look at the file in this link:

http://dl.dropbox.com/u/60558749/formula%20to%20look%20up%20the%20ID%20%23%20in%20one%20worksheet%20and%20return%20all%20records%20from%20another%20%28for%20ReneeK%20at%20chandoo.org%29.xlsx


It uses a technique with a helper column at leftmost of the data table, you can find additional details searching here into chandoo website.


Regards!