Hi,

am trying to find out the formula that should be used to resolve the
following:


Position HR Manager (drop-down list)
Incumbent
Grade
Manager


in another sheet, i've got all the information hidden relavent to the HR
manager, and other staff, like

Position Incumbent Grade Manager
HR Manager Hanan 2 Majid
DM OD Nazia 3 Hanan
DM PM Alison 3 Hanan
Specialist A George 4 Nazia
Specialist A Haitham 4 Alison


I want to show the HR manager info like name, grade and manager in their
relavent fields in the first table, if i choose the HRM, the data from this
sheet can be populated in the 2nd sheet.. !

HELP!!!