Value look up
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!!!
|