Value look up

[Batshon]

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!!!

 

[Pete_UK]

Assume Sheet1 contains the table of data, in columns A to D, and that
your drop-down is in B1 of Sheet2. Put these formulae in the cells
stated:

B2: =VLOOKUP(B$1,Sheet1!A,2,0)

B3: =VLOOKUP(B$1,Sheet1!A,3,0)

B4: =VLOOKUP(B$1,Sheet1!A,4,0)

You can see that the formulae are very similar - the only thing that
changes is the third parameter, which determines which column to get
the data from (and you could change this to ROW() if you are using the
same setup as I suggest).

Hope this helps.

Pete