Calling data from master sheet

[Natraj Vaddadi]

I have a master data sheet with several columns. One of the column is the person ID. I would like to call data pertaining to a specific person ID to another worksheet on typing only the person ID.

 

[Somendra Misra]

Hi Natraj,

If the person ID's are unique, try VLOOKUP function.

Regards,

 

[Deepak]

I have a master data sheet with several columns. One of the column is the person ID. I would like to call data pertaining to a specific person ID to another worksheet on typing only the person ID.

Hi,

In Addition to what Somendra Misra said: If you still having issue/confutation then pls share the sample workbook.
You may also loop at below url's for Vlookup.

http://www.techonthenet.com/excel/formulas/vlookup.php

http://office.microsoft.com/en-in/excel-help/vlookup-HP005209335.aspx

http://office.microsoft.com/en-in/excel-help/vlookup-function-HP010343011.aspx