Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Value look up
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!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|