Value look up

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Batshon - 04 May 2008 15:13 GMT

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

Reply to this Message

Pete_UK - 05 May 2008 10:31 GMT

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

> Hi,
>
[quoted text clipped - 21 lines]
>
> HELP!!!

Reply to this Message