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:D,2,0)

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

B4: =VLOOKUP(B$1,Sheet1!A:D,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

On May 4, 3:13*pm, Batshon wrote:
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!!!